I am using the TEXT function to convert field date_Field_ABC values like so: =TEXT([@[date_Field_ABC]], "mm-dd-yyyy") which works fine, but how do I extend the same TEXT formula so that the default values of 01-00-1900 do not show at all (from when date_Field_ABC is empty)? Thank you
CodePudding user response:
Try something like:
=TEXT([@[date_Field_ABC]], "mm-dd-yyyy;;;")
In my comment I included the conditional [>0]
but it isn't necessary and should be omitted.
The format string is interpreted as:
- return a formatted date for a positive value
- return nothing for a negative value, zero value, or text value