Forum Discussion

Elie_HUCHET's avatar
Elie_HUCHET
Icon for Helper III rankHelper III
4 years ago
Solved

day subtraction

Hello I would like days on today's date.
For me the formula would be =Date.AddDays(DateTime.FixedLocalNow,-90) but it doesn't work.

 =Date.AddDays(DateTime.FixedLocalNow,-90)

Also, I have a "function" message that appears and therefore I cannot transform my data thanks in advance.

Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    () should be appended to FixedLocalNow.

    =Date.AddDays(DateTime.FixedLocalNow(),-90)

1 Reply

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    () should be appended to FixedLocalNow.

    =Date.AddDays(DateTime.FixedLocalNow(),-90)