if statement returns true instead of date

[Anonymous]

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 without the else?

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)

[lukiz84]

Yes, because you return a boolean value with this part:

then (Date.From([FINISH_DATE]) >= Date.AddDays(Date.From(DateTime.LocalNow()),-1))

What do you want to achieve?

[Anonymous]

I want to return a date

[lukiz84]

which date? your formular returns a boolean because of THIS part:

then (Date.From([FINISH_DATE]) >= Date.AddDays(Date.From(DateTime.LocalNow()),-1))

[Anonymous]

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)

[lukiz84]

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 · Accepted solution]

Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense

[Anonymous]

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

[lukiz84]

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?

[Anonymous]

Basically the date i want should be FINISH_DATE that is Greater than Today Plus 1 if that makes Sense