4 Replies Latest reply: Jul 26, 2018 6:37 AM by Ali Ahmad RSS

    Transform data into date format

    Juan Julian Herranz Sarrion

      Hello everyone,

       

      Quick question. I am trying to convert the current dates into a format that can be interpreted by qlik sense. I have tried every possible function to make it work: Date(RESPONSE_DATE,'MMMMYY'), Date#(RESPONSE_DATE, 'MMMMYY'), Date(Date#(RESPONSE_DATE, 'MMMMYY'),'MMMMYY'), Floor(RESPONSE_DATE), Year(RESPONSE_DATE), Month(RESPONSE_DATE) but none of them work and when applied they return a dash.

       

      Is anyone capable of transforming it?

       

      Thank you