Forum Discussion
if statement returns true instead of date
Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense
I want to return a date
which date? your formular returns a boolean because of THIS part:
then (Date.From([FINISH_DATE]) >= Date.AddDays(Date.From(DateTime.LocalNow()),-1))
i want this query to return a date :
if((Date.From([ACT_START_DATE]) <>"" ) and (Date.From([ACT_END_DATE]) = "") or
(Date.From([START_DATE]) <= Date.AddDays(Date.From(DateTime.LocalNow()),2))) then (Date.From([FINISH_DATE]) >= Date.AddDays(Date.From(DateTime.LocalNow()),-1)) else null)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
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