2 Replies Latest reply: Jan 31, 2018 12:08 AM by Tresesco B RSS

    QlikSense Date Variable Issue

    vikas mahajan

      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 ?