YYYYMMWW

[#1]

Hi,

How to create YYYYMMWW from date in script.

Rahul

[#2 · Accepted solution]

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

$@M

[jagan]

Hi,

Try like this

Data:

LOAD

*,

Date(Today(), 'YYYYMM') & Num(Week(Today()), '00') AS YYYYMMWW

FROM DataSource;

Regards,

Jagan.

[anbu1984]

Date(DateField,'YYYYMM') & Right('0'&Week(DateField),2) As DateField

[maxgro]

load

     .....,

     date(yourdatefield, 'YYYYMM') & num(Week(yourdatefield), '00') as NewField,

     .....

from

     yoursource;