Skip to Content
0
Jan 19, 2023 at 09:44 AM

How do I: If Date is 01/01/1900 then show a blank value

90 Views

This is how I tried to convert a date value of 01/01/1900 to blank:

iif ({V_ORDER_LINES.NO_DLVR_BEFORE_DATE} = #1/1/1900# , "" , {V_ORDER_LINES.NO_DLVR_BEFORE_DATE})

But I get an error stating that a sting value is requires in the bolded section.