topic How to change a date field date format? in QlikView

How to change a date field date format?

jim_chan — Wed, 03 Oct 2018 10:25:22 GMT

Hi guys,

When loaded to the qvw - my date field data has convert to 10OCT2018.

I want to change the date format to 10/10/2018, how to change it?

i have tried on this formula, but the result came out was empty, nothing is out.

date(date#(my_date,'ddmmmyyyy'),'dd-mmm-yyyy') as my_date1.

Which part is wrong???

Rgds,

Jim Chan

sunny_talwar — Wed, 03 Oct 2018 10:28:10 GMT

Try this may be

date(date#(my_date, 'ddMMMyyyy'), 'dd/MM/yyyy') as my_date1

jim_chan — Wed, 03 Oct 2018 10:31:34 GMT

Sunny, Thanks again! long time no see! if you still remember me

haha

jaumecf23 — Wed, 03 Oct 2018 10:31:54 GMT

Hi,

Try this:

=date(date#(my_date,'ddMMMyyyy'),'dd/MM/yyyy')

jim_chan — Wed, 03 Oct 2018 10:34:47 GMT

Sunny,

I have another file - but date format is as below, it has timestamp as well, so how to change it to 10/10/2018?

date data as this: 10OCT2018:15:37:56

sunny_talwar — Wed, 03 Oct 2018 10:40:59 GMT

Try this

Date(Floor(Date#(DateField, 'DDMMMYYYY:hh:mm:ss')), 'DD/MM/YYYY') as DateField

jim_chan — Wed, 03 Oct 2018 10:49:43 GMT

thanks bro, i will try it out, then let u know bro!

jim_chan — Thu, 04 Oct 2018 01:45:49 GMT

Bro.! Its correct! thanks!