How to change a date field date format?

[jim_chan]

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 · Accepted solution]

Try this may be

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

[jim_chan]

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

haha

[jaumecf23]

Hi,

Try this:

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

[jim_chan]

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]

Try this

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

[jim_chan]

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

[jim_chan]

Bro.! Its correct! thanks!