Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi try this:
=Date(Date#('30NOV12 00:00:00','DDMMMYY hh:mm:ss'),'DD/MM/YYYY')
HTH
Sushil
where to insert my date field?
=Date(Date#(DateField,'DDMMMYY hh:mm:ss'),'DD/MM/YYYY')
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
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);
Try this:
Date(Date#(final_date,'DDMMMYY:hh:mm:ss'),'DD/MM/YYYY') as use_this_date,