fonction date

[pirotfab]

Hello,

Do you know a function that gives me automatically?

the date of the last year - 1 day  : depending on the selection.

(EX:  today = 02/03/2016, I want the variable 01.03.2015)

My variable = date (Num (Today ()) - 367, 'DD / MM / YYYY')

the "367" is good only for this year.

Thank you in advance

Fabien

[sunny_talwar]

This year is 367 or 366?

You can use AddYears() function

AddYears(Today(), -1)

[Peter_Cammaert · Accepted solution]

Even better:

AddYears(Today(), -1) - 1

[pirotfab]

Thanks,

AddYears(Today(), -1) -1 its perfect

[Peter_Cammaert]

If your question has been answered to satisfaction, please close the discussion by marking an answer as Correct. That answer will appear in the same frame as your original post at the top, making it easier for other Community Members to find Question & Answer. Thanks.

Peter