All I need is a simple date formula that shows the date if a date exists in the table/field. If a date has not been entered in the table/field, I would like it to show as "N/A".
Here is the formula I have tried:
if {tblPrimDls.PDLine} = "" then "N/A" else {tblPrimDls.PDLine}
tblPrimDls.PDLine is a Date/Time field in MSAccess Database.
Error I am getting:
A date is required here. Focus is then given to ""
Here is the formula I have tried:
if {tblPrimDls.PDLine} = "" then "N/A" else {tblPrimDls.PDLine}
tblPrimDls.PDLine is a Date/Time field in MSAccess Database.
Error I am getting:
A date is required here. Focus is then given to ""