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 your formula is working fine. can you please advise what was the mistake in my formula?
there are many data type in your data. DateTime.FromText is only used to convert Text to DateTime, So, your first two conditions will get errors when the value is a datetime already. And, Text and DateTime can not be concatenated directly, that will give a error too.