Forum Discussion

Advocate I

3 years ago

Solved

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

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

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

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