I have a field called XDESC2, this field is defined as varchar2 in the backend even though the field has date/time value saved in it. The date is saved in ddmmyyyy format. I got a request from the user to add 90 dates to date, so I wrote below formula which worked:

 

Dateadd('d', 90,(cdate({UDEFTAB.XDESC2})))

 

Now the user is asking me to change the record selection formula to include XDESC2 field as well when the field is not null. In another words is to display the values on the report whenever this field contains data.

 

The current selection formula is as below:

(not isnull({UDEFTAB.XDESC1})

 

I changed the existing record selection formula to:

 

((not isnull({UDEFTAB.XDESC1}) or (not isnull({UDEFTAB.XDESC2}))

 

 

After I added XDESC2 to the selection formula, I got error message complaining about the first formula is a bad date format string.

 

I thought may be because in my first formula I changed the data type to date, I might need to add cdate, (not isnull(cdate({UDEFTAB.XDESC2})), but this did not help either. By doing so, I got a field is required here error message.

 

Can someone please tell me what I am missing here?

 

Thanks,

Lava

 

Thanks,

Lava