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

[wyanjaspew]

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

[Mekist]

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

[Mekist]

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)))

[Anonymous · Accepted solution]

...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