Transform data into date format

[Anonymous]

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

[Anonymous]

I intend to then link this data to my link table and the dates to match the ones in my master calendar.

[bwisealiahmad · Accepted solution]

Hi,

First interpret it and then you can wrap it with a Date function to show it how you want it shown.

1. Date#(RESPONSE_DATE,'DD.MM.YY') - Intepret with Date#() Function.
2. Date(Date#(RESPONSE_DATE,'DD.MM.YY'),'DD.MM.YYYY') - Change formatting with the Date() Function.

So what you end up with is:

    Date(Date#(RESPONSE_DATE,'DD.MM.YY'),'DD.MM.YYYY') AS RESPONSE_DATE

And this is what it will look like afterwards:

Best,

Ali A

[Anonymous]

Thank you Ali,

Although I was interpreting it, I was trying to give it the format I wanted to end up in directly. Hence it wasn't working. I will remember it now for future times!!

[bwisealiahmad]

Notice this part:

Date(Date#(RESPONSE_DATE, 'MMMMYY'),'MMMMYY')

That should have been DD.MM.YY

You are basically telling Qlik what date format the source is in, which is DD.MM.YY and not MMMMYY and then when it knows that you can of course change that to whatever you want like maybe MMMMYY.

Cheers,

Ali