Format of Date

[mohan2391]

Hi,

I have a date field as below.

How to change the format of this field to "DD/MM/YYYY" ?

Thank You....

[Chanty4u · Accepted solution]

try like below

a:

LOAD * INLINE [

    Mydate

    20150815

    20160912

];

Result:

LOAD *,

Date(date#(Mydate,'YYYYMMDD'),'YYYY/MM/DD') AS newDate

Resident a;

[jjbom1990]

In your load script:

date(Right(REV_REC_DAY,2)&'-'&Mid(REV_REC_DAY,5,2)&'-'&left(REV_REC_DAY,4),'DD/MM/YYYY') as REV_REC_DAY

[jjbom1990]

This solution is a bit cleaner.

[Anonymous]

Hi,

Use this in load script Date(Floor(REV_REC_DAY),'DD/MM/YYYY') as REV_REC_DAY

-Sweta

[dineshm030]

Hi,

You can this in Expression Area:

=Date(Date#(REV_REC_DAY,'YYYYMMDD'),'DD/MM/YYYY') as REV_REC_DAY

[#7]

Use the below in your script

[#8]

Use the below in your script

Date(Date#(REV_REC_DAY,'YYYYMMDD'),'DD/MM/YYYY')

[mohan2391]

It has given some wrong data for Year.

[nitin_01]

Hi Mohan,

Try this:

                    Date(TimeStamp#(REV_REC_DAY),'YYYYMMDD'),'DD/MM/YYYY')

Regards,

Nitin