QlikSense Date Variable Issue - Qlik Community

vikasmahajan · ‎2018-01-30

Dear all,

I am storing a date into Variable vLMaxDate like =date(addyears(max([Posting Date]),-1), 'DD/MM/YYYY') when i view this variable i am getting wrong date result 16/jun/1900 actually it should 01/12/2016.

My date format is DD/MM/YYYY HH:MM:SS AM/PM

Any idea what will be the issue ?

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

prma7799 · ‎2018-01-30

Check format for Posting Date

try this in vDT

=Max(date([Posting Date], 'DD/MM/YYYY'))

tresesco · ‎2018-01-31

This is perhaps a format issue. Try using parsing function like:

=date(addyears(max(Date#([Posting Date],'DD/MM/YYYY HH:mm:SS TT')),-1), 'DD/MM/YYYY')

Note: 'MM' (month) and 'mm' (minute) are different and that alone potentially can trouble you.

Edit: corrected a bracket