topic Change date field format in QlikView

Change date field format

jim_chan — Fri, 21 Oct 2016 03:22:06 GMT

Hi guys,

i have a date field with data: 30NOV12 00:00:00.

How can i change it to format DD/MM/YYYY '30/11/2012' ?

Rgds

Jim

sushil353 — Fri, 21 Oct 2016 03:33:29 GMT

Hi try this:

=Date(Date#('30NOV12 00:00:00','DDMMMYY hh:mm:ss'),'DD/MM/YYYY')

HTH

Sushil

jim_chan — Fri, 21 Oct 2016 03:35:47 GMT

where to insert my date field?

sushil353 — Fri, 21 Oct 2016 03:44:36 GMT

=Date(Date#(DateField,'DDMMMYY hh:mm:ss'),'DD/MM/YYYY')

jim_chan — Fri, 21 Oct 2016 03:57:00 GMT

I have tried with

Date(Date#(final_date,'DDMMMYY hh:mm:ss'),'DD/MM/YYYY') as use_this_date,

but after loaded in, it shows empy data in this field. i have attached the sample data here. Can you try it out, Sushil?

RGds

Jim

sunny_talwar — Fri, 21 Oct 2016 04:05:21 GMT

Your format is DDMMMYYYY:hh:mm:ss, so try this:

Date(Date#(final_date,'DDMMMYY:hh:mm:ss'),'DD/MM/YYYY') as use_this_date,

Update:

Table:

LOAD final_date,

Date(Date#(final_date,'DDMMMYY:hh:mm:ss'),'DD/MM/YYYY') as use_this_date

FROM

date_samples.xlsx

(ooxml, embedded labels, table is Sheet1);

sushil353 — Fri, 21 Oct 2016 04:07:56 GMT

Try this:

Date(Date#(final_date,'DDMMMYY:hh:mm:ss'),'DD/MM/YYYY') as use_this_date,