Joined: 22 Jun 2010
Online Status: Offline
Posts: 1
Topic: Change Date to NULL value Posted: 13 Dec 2012 at 4:22am
i am creating a report in CR 2008, where if an object is not closed it will auto input a date as
1/1/190012:00:00 AM
i want to change this field to display as "NULL"
I have tried
and if {vANDON_REQUEST.CLOSE_DT} = '1/1/1900 12:00:00 AM' then 'NULL'
but i keep getting a date-time is required here error. I have tried altering the way the date is displayed and even tried putting in a date time function to no avail.... can anyone assist me in getting this field to show as blank??
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
