topic Re: fonction date in QlikView

fonction date

pirotfab — Wed, 02 Mar 2016 15:58:35 GMT

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

Re: fonction date

sunny_talwar — Wed, 02 Mar 2016 18:30:17 GMT

This year is 367 or 366?

You can use AddYears() function

AddYears(Today(), -1)

Re: fonction date

Peter_Cammaert — Wed, 02 Mar 2016 20:35:45 GMT

Even better:

AddYears(Today(), -1) - 1

Re: fonction date

pirotfab — Thu, 03 Mar 2016 07:47:58 GMT

Thanks,

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

Re: fonction date

Peter_Cammaert — Thu, 03 Mar 2016 23:19:49 GMT

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