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

    Convert yyyymmdd to dd/mm/yyyy

    Hasvine Dhurmea

      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:

      21//2015.

       

      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,

       

      Hasvine