12 Replies Latest reply: Nov 15, 2017 4:31 PM by Lorenzo Thurman RSS

    Formatting a date using the Expression Editor

    Lorenzo Thurman

      Hello Qlik Sense Community,

      I need to convert a date variable from this format 201701 to Jan 2017. I tried using Date and Date#, but instead of getting the short month and year, I only get the year. Our variable name is BillingDate and I use it like this:

      Date(Date#(BillingDate, 'YYYYMM'), 'MMM YYYY')

       

      I've also tried using MM as part of the output format, but I still only get the year. Any ideas as to where I may be going wrong?

      Thanks