null value for a date
-
- Posts: 10
- Joined: Tue Oct 10, 2017 12:44 pm
null value for a date
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
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