Unable to change a date format

[jim_chan]

HI there,

i have problem changing 1 of my date column to another format - mydate

i used code as such  -  Date("Start Date",'DD-MM-YYYY') as mydate , why my year become "57069" ?

Rgds

Jim

[qlikmsg4u · Accepted solution]

Try this

=Date(Date#(StartDate,'YYYYMMDD'),'DD-MM-YYYY')

[SreeniJD]

Hi Jim

As you know, your startdate is not in the correct date format... you have to use date# function as mentioned below..

=Date(date#("Start Date"'),'DD-MM-YYYY') as mydate

Happy to help!

Sreeni

[jim_chan]

Can you explain why has to put "Date#" , then (StartDate,'YYYYMMDD') ? i know this is the format 'DD-MM-YYYY'

[jim_chan]

I thought the "Date" is already a date function?

[qlikmsg4u]

First you have to tell qlikview that your Start Date is a date field in the format of YYYYMMDD, for this you have to use Date# interpretation function next you need to format the date to your desired format using Date formatting function.

[jim_chan]

thank you

[jim_chan]

thank you

[qlikmsg4u]

Welcome