NZ() doesnt work for date range

[tagteam]

I am trying to use NZ or an IF statement to determine a date range or if nothing entered look for all data. I have two field boxes one for BeginDate one for EndDate. If the user puts dates in I want to use those and if the user does not then I can use a date from the first entry and the current date.



NZ(between [forms]![f_validate]![BeginDate] AND [forms]![f_validate]![EndDate], between #1/1/1960# AND Now())

Or

IIF([forms]![f_validate]![BeginDate] AND [forms]![f_validate]![EndDate] is Null, between #1/1/1960# AND Now(), between [forms]![f_validate]![BeginDate] AND [forms]![f_validate]![EndDate])

But neither of them seem to work

[pbaldy]

You haven't used it properly. Try

between Nz([forms]![f_validate]![BeginDate], #1/1/1960#) AND Nz([forms]![f_validate]![EndDate], Now())

[tagteam]

yep, silly me. I should have thought of that. I tried it and it works fine.
Thanks

[pbaldy]

No problemo.