5 Replies Latest reply: Nov 18, 2011 6:41 AM by Adam Marshall RSS

    Change date from CYYMMDD to DD/MM/YY ?

    Adam Marshall

      Hi Guys

       

      New to QlikView (obviously ) and i've been looking at examples to change the date format date(date#(replace.... but i cant get it to convert our dates from our iSeries into a decent format. We have it in CYYMMDD so 1111118 would be todays today. I'd prefer to change it to 18/11/11. Sadly i've been unable to work out the syntax properly to do this. Anyone have any idea's ?

       

      Cheers !

       

      Adam