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 I have facing a Date format issue. your formula is giving DateTime format whereas I am looking for Date format only as in below picture.
=if not([Date] is datetime) then "N/A" else (if [Date]< DateTime.LocalNow() then "" else "Est. ")&DateTime.ToText([Date],"dd/MM/yyyy")