Am writing an "if" calculation on a date field where I want the "if no" result to be a blank date field - how do you write this?
It's " " for a character field
What would it be for a date field?
A blank date field would probably be a null value - which you can get with ctod("") in your expression. ctod() is "character to date" conversion, and ctod("") will generate a valid date field but with a null value.
Hope this helps,
Thanks Olly, have displayed the null values as blanks, as data is ultimately exported to Access, so works great.
Retrieving data ...