Forum Discussion
DateTime with If condition
I have shared a simple dummy chart. I want to convert the date with the below 03 conditions- 1. If the Date does not exist, then it will return "N/A" 2. If the Date is less than today's date, then...
not([Date] is datetime)
wdx223_Daniel is working fine. you are great.
=if not([Date] is datetime) then "N/A" else if [Date]< DateTime.LocalNow() then [Date] else "Est. "&DateTime.ToText([Date])