Forum Discussion

Elie_HUCHET's avatar
Elie_HUCHET
Helper 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.

  • () should be appended to FixedLocalNow.

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

1 Reply

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

    () should be appended to FixedLocalNow.

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