format problem

[#1]

Hi all,

in my script i generate a calendar:

Load

          Date(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) as Date_,

          Year(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) & Num(Month(Date#('1/1/2008','D/M/YYYY')+RowNo()-1), '00') as M_,

          WeekDay(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) as WeekDay_

AutoGenerate

          Interval(Date#('31/12/2015','D/M/YYYY')-Date#('1/1/2008','D/M/YYYY'),'D');

The problem is that i need:

Year(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) & Num(Month(Date#('1/1/2008','D/M/YYYY')+RowNo()-1), '00') as M_,

to be in a real date format YYYYMM instead of a concatenated number.

Can someone help me formatting this ?

Thanks a lot!

[swuehl]

Maybe like

Date(Date#('1/1/2008','D/M/YYYY')+RowNo()-1),'YYYYMM') as M_,

[#3]

Something seems to be not right with the ) after the 'YYYYmMM'

[CELAMBARASAN]

Hi,

     Try with this

     Date((Date#('1/1/2008','D/M/YYYY')+RowNo()-1),'YYYYMM') as M_

instead of

     Year(Date#('1/1/2008','D/M/YYYY')+RowNo()-1) & Num(Month(Date#('1/1/2008','D/M/YYYY')+RowNo()-1), '00') as M_,

Celambarasan

[swuehl · Accepted solution]

Yes, one ')' too many:

=Date(Date#('1/1/2008','D/M/YYYY')+RowNo()-1,'YYYYMM') as M_,