Converting a date

[GregRyder]

Hi 

How do I convert the Date YYYYMM from an excel file back into a DD/MM/YYYY format in QlikSense

Here is the data load line Date("Date",'YYYYMM') as "Date", (It doesn't matter if all of these land up on the last or first day of the month

The rest of the sales files I bring in are Date(TXDATE,'DD/MM/YYYY') as TXDATE,

and I need them in the same format for the Date Picker to work

Thanks

Greg

[Raja2022]

Please give a try with below:

=Date(Date#(202205,'YYYYMM'),'DD/MM/YYYY')

Hope this helps..

[GregRyder · Accepted solution]

Hi 

Thanks that gave me an Idea

here is the code I used in Data Load Editor

Date(Date#(Date,'YYYYMM'),'DD/MM/YYYY') as Date, and it converted all the dates to the 1st of every month which is all i needed.

[Raja2022]

Glad able to help.... Have a nice day...