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)
if not([Date] is date) then "N/A" else if [Date]< DateTime.LocalNow() then [Date] else "Est. "&DateTime.ToText([Date])