Change date field format

[jim_chan]

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]

Hi try this:

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

HTH

Sushil

[jim_chan]

where to insert my date field?

[sushil353]

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

[jim_chan]

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

[sushil353]

Try this:

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