Forum Discussion
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 ...
Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense
sorry i missed your question i apologize for that- Basically, it to return Finish Date plus Today Plus 1 as in one day into the future
No need to apologize, I was just wondering 🙂
But I still don't really get it. Could you add some sample date?
E.g. FINISH_DATE='2022-09-30' - what do you want to return?
Or do you want to return some date (then which date) if FINISH_DATE is greater than today+1?