Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a date field as below.
How to change the format of this field to "DD/MM/YYYY" ?
Thank You....
try like below
a:
LOAD * INLINE [
Mydate
20150815
20160912
];
Result:
LOAD *,
Date(date#(Mydate,'YYYYMMDD'),'YYYY/MM/DD') AS newDate
Resident a;
try like below
a:
LOAD * INLINE [
Mydate
20150815
20160912
];
Result:
LOAD *,
Date(date#(Mydate,'YYYYMMDD'),'YYYY/MM/DD') AS newDate
Resident a;
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
This solution is a bit cleaner.
Hi,
Use this in load script Date(Floor(REV_REC_DAY),'DD/MM/YYYY') as REV_REC_DAY
-Sweta
Hi,
You can this in Expression Area:
=Date(Date#(REV_REC_DAY,'YYYYMMDD'),'DD/MM/YYYY') as REV_REC_DAY
Use the below in your script
Use the below in your script
Date(Date#(REV_REC_DAY,'YYYYMMDD'),'DD/MM/YYYY')
It has given some wrong data for Year.
Hi Mohan,
Try this:
Date(TimeStamp#(REV_REC_DAY),'YYYYMMDD'),'DD/MM/YYYY')
Regards,
Nitin