7 Replies Latest reply: Oct 21, 2015 5:05 AM by Hirish V RSS

    Convert yyyymmdd to dd/mm/yyyy

      Hello All,


      I have an issue while converting a date from 'yyyymmdd' to 'DD/MM/YYYY'.


      I am using the below formula in my Load script:


      Date(alt(Date#(DATE, 'yyyymmdd')), 'DD/MM/YYYY') as Date


      It gives me the correct answer in my table on qlikview.

      Ex. 21/10/2015

      However when I export the table in excel it becomes like this:



      Also, when i try using the expression =if(Date= today(), Date) to get the data of only today, my table becomes empty.


      Any idea why?


      Many Thanks,