Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This year is 367 or 366?
You can use AddYears() function
AddYears(Today(), -1)
Even better:
AddYears(Today(), -1) - 1
Thanks,
AddYears(Today(), -1) -1 its perfect
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