Forum Discussion

wyanjaspew's avatar
wyanjaspew
Advocate I
3 years ago
Solved

Date.AddDays(DateTime.LocalNow(), (-3))

Hi Sirs / M'am,
anyone can help please. thanks

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    ...Date.AddDays(DateTime.LocalNow(), -3))

     

    Note that you are using a datetime value to test equality against what appears to be a date column. I would wrap DateTimeLocalNow() with a Date.From, so

     

    Date.AddDays(Date.From(DateTime.LocalNow()), -3))

     

    --Nate

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    ...Date.AddDays(DateTime.LocalNow(), -3))

     

    Note that you are using a datetime value to test equality against what appears to be a date column. I would wrap DateTimeLocalNow() with a Date.From, so

     

    Date.AddDays(Date.From(DateTime.LocalNow()), -3))

     

    --Nate

  • Mekist's avatar
    Mekist
    Helper III
    1 year ago

    Hello

    I wanted to take out the day by translating the date into text, can you help

    DateTime.ToText(Date.From(Date.AddDays(DateTime.LocalNow(), "dd-MM-yyyy", -3)))

  • Mekist's avatar
    Mekist
    Helper III
    1 year ago

    Hello
    If the date falls on the weekend, how should I say -2 days out?