null value for a date

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Katie_(Guest)
Posts: 10
Joined: Tue Oct 10, 2017 12:44 pm

null value for a date

Post by Katie_(Guest) » Thu Feb 28, 2008 4:59 pm

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.

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: null value for a date

Post by kfleming » Mon Mar 03, 2008 9:36 am

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

Post Reply