Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to create YYYYMMWW from date in script.
Rahul
Hi Rahul,
Please find the below script
hope it will be usefull.
=Num(Year(DateField),'0000') & Num(Month(DateField),'00') & Num(Week(DateField),'00')
Regards
Hi Rahul,
Please find the below script
hope it will be usefull.
=Num(Year(DateField),'0000') & Num(Month(DateField),'00') & Num(Week(DateField),'00')
Regards
Hi,
Try like this
Data:
LOAD
*,
Date(Today(), 'YYYYMM') & Num(Week(Today()), '00') AS YYYYMMWW
FROM DataSource;
Regards,
Jagan.
Date(DateField,'YYYYMM') & Right('0'&Week(DateField),2) As DateField
load
.....,
date(yourdatefield, 'YYYYMM') & num(Week(yourdatefield), '00') as NewField,
.....
from
yoursource;