Return blank date

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

Return blank date

Post by Smzemke_(Guest) » Mon Jun 06, 2005 12:25 pm

How do I get an iif statement to return a blank date?____ex.____IIF(A1=True,{5/06/05},<Blank date>)____Thanks
Top
kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Return blank date

Post by kfleming » Mon Jun 06, 2005 12:50 pm

IIF(A1=True,{5/06/05},{ / / }) ____will work.____Kathleen__R&R Support
Top
Smzemke_(Guest)
Posts: 41
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Return blank date

Post by Smzemke_(Guest) » Mon Jun 06, 2005 1:36 pm

I get an "invalid argument" error. ?
Top
Smzemke_(Guest)
Posts: 41
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Return blank date

Post by Smzemke_(Guest) » Mon Jun 06, 2005 2:30 pm

I got it!____I was using a date field as the true value, and I needed to use "TODATE()"____Then it worked.____Thanks!
Top
Post Reply

Return to “R&R ReportWorks Users”