Page 1 of 1

null value for a date

Posted: Thu Feb 28, 2008 4:59 pm
by Katie_(Guest)
What is the null value in R&R Infinity for a date? In prior values, we used curly brackets {}. This no longer works. I get an invalid argument message. ____Example of what used to work, and no longer does:__ IIF(CLOSEDATE<>{}, CLOSEDATE, {})____Thanks for your help.

=> RE: null value for a date

Posted: Mon Mar 03, 2008 9:36 am
by kfleming
Is Closedate really a date time field rather than a date field?____If so try:__IIF(TODATE(CLOSEDATE)={},todate(closedate),{})____and you should not get an error.____Kathleen__R&R Support