Forum Discussion
Anonymous
3 years agoNot applicable
if statement returns true instead of date
ave this Power query that i need it to return a date value but its returning a true or false, Is there anyway to make it return a date value instead of true / false? Also how can i end the statement ...
- Anonymous3 years ago
Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense
lukiz84
3 years agoMemorable Member
do you even read what i write?
this query will never return a date because you have >= in your "then" part. Do you want to return "FINISH_DATE" or do you want to substract something? I still don't know which date you want to return 😄
BR
Anonymous
3 years agoNot applicable
Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense