Forum Discussion
Expression.Error: We cannot apply operator - to types Date and Number.
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
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/
2 Replies
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/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.
