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 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
Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense
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?
Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense