Power Query if Date between

[Anonymous]

Hello, 

I'm not very good to Power Query and I don't know why it doesn't work : 

if [Order created] >= 2022-01-01 & [Order created] <= 2022-12-31 then 1 else 0

Thank you for your help

[Anonymous · Accepted solution]

if[Date] >= #date(2022,01,01) and [Date] <= #date(2022,12,31)then 1 else 0

[Anonymous]

This didn't work for me, the entire formula worked until I put text in after then.

Could you take a look and see if you know the solution:

IF ([CancelTime] - [StartTime]) >= Time.Minute(10) and Time.Minute (18) then "Yes" else ""

only the "Yes" is failing and I can't seem to resolve it.

[Anonymous]

Without seeing the data it's difficult to give a correct answer. If you keep the calculation within one set of brackets maybe it will work?