Forum Discussion
Solved
Date Comparison
Hi This might sound silly but I'm not able to get around this problem. = If (StartDate > Today()) then "Hello" Else "Bye" Now() / Today () function just doesn't work Thanks for the...
Try with this
if [Calendar] > DateTime.Date(DateTime.LocalNow()) then "Hello" else "Bye" )
Are you in Query Editor?
Yes and adding a new column in query editor
In Query Editor, capitilaization matters. Use if instead of If in your original statement.
Here is more information on IF http://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/
Try with this
if [Calendar] > DateTime.Date(DateTime.LocalNow()) then "Hello" else "Bye" )
