Page 1 of 1
Return blank date
Posted: Mon Jun 06, 2005 12:25 pm
by Smzemke_(Guest)
How do I get an iif statement to return a blank date?____ex.____IIF(A1=True,{5/06/05},<Blank date>)____Thanks
=> RE: Return blank date
Posted: Mon Jun 06, 2005 12:50 pm
by kfleming
IIF(A1=True,{5/06/05},{ / / }) ____will work.____Kathleen__R&R Support
==> RE: Return blank date
Posted: Mon Jun 06, 2005 1:36 pm
by Smzemke_(Guest)
I get an "invalid argument" error. ?
==> RE: Return blank date
Posted: Mon Jun 06, 2005 2:30 pm
by Smzemke_(Guest)
I got it!____I was using a date field as the true value, and I needed to use "TODATE()"____Then it worked.____Thanks!