Expression.Error: We cannot apply operator - to types Date and Number.

[FranckGbadamass]

Hello everyone,

How can I fix this error:

Expression.Error: We cannot apply operator - to types Date and Number.

Details:
Operator=-
Left=20/04/2022
Right=1

I'd like to substract 1 from the date.

Thank you

[v-stephen-msft]

Hi @FranckGbadamass ,

I may have reproduced your wrong scenario.

You should use Date.ToText() and Number.ToText().

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tackytechtom · Accepted solution]

Hi @FranckGbadamass ,

You might wanna consider this M Power Query:

Date.AddDays ( [Merged.1], -1 )

Does this help?

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/