convert 20130416 into date format 2013/04/16

[#1]

Dear All,

How can I convert date comming from source as 20130416 to Date as 'yyyy,mm,dd'

[fdelacal · Accepted solution]

IN SCRIPT WRITE.

DATE(Date#(YOURFIEDL,'YYYYMMDD'),'YYYY/MM/DD') AS DATE

HOPE THAT HELPS YOU.

[Gysbert_Wassenaar]

like this: date(date#('20130416','YYYYMMDD'),'YYYY,MM,DD') if you want 2013,04,16 or date(date#('20130416','YYYYMMDD'),'YYYY/MM/DD') if you want 2013/04/16

[jagan]

Hi,

Try with Date# and Date functions like this

=Date(Date#('20130416','YYYYMMDD'),'YYYY,MM,DD'))

Hope this helps you.

Regards,

Jagan.