Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

Change date field format

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

6 Replies
sushil353
Master II
Master II

Hi try this:

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

HTH

Sushil

jim_chan
Specialist
Specialist
Author

where to insert my date field?

sushil353
Master II
Master II



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

jim_chan
Specialist
Specialist
Author

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

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);

Capture.PNG

sushil353
Master II
Master II

Try this:

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