#error in date calculation

[bdm1]

I am using the query grid to calculate a future date based on a specific date field. All is fine except #error appears if there is no value in the specific date field. This is the code in the query grid:

Next IEP: DateSerial(Year([Last iep date]),Month([Last iep date])+6,Day([Last iep date]))

I have tried various ways to avoid the #error but can't seem to get the syntax right. Any help is much appreciated.

Bdm

 

[PHV]

Next IEP: IIf([Last iep date] Is Null, Null, DateSerial(Year([Last iep date]),Month([Last iep date])+6,Day([Last iep date])))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Hi,

How about...
[tt]
Next IEP: IIF([Last iep date]=0,[Last iep date],(DateSerial(Year([Last iep date]),Month([Last iep date])+6,Day([Last iep date])))
[/tt]
Might also be IIF([Last iep date] Is Null...

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]