Date fields

[surajap123]

Hi All,

Could anyone help me with creation of date fields(Year,Month, Day) to my autogenerate table below, so that i can use as list boxes in front end of my app-

LOAD

  WeekStart(date(Today() - RecNo()*7)) as Weekstart,

  WeekEnd(date(Today() - RecNo()*7)) as Weekend

autogenerate 100;

[Gysbert_Wassenaar · Accepted solution]

Use a preceding load:

LOAD *,

     Year(Weekstart) as Year,

     Month(Weekstart) as Month,

     Week(Weekstart) as Week,

     Day(Weekstart) as DayWeekstart,

     Day(Weekend) as DayWeekend;

LOAD

  WeekStart(date(Today() - RecNo()*7)) as Weekstart,

  WeekEnd(date(Today() - RecNo()*7)) as Weekend

autogenerate 100;

[surajap123]

Thanks you so much Gysbert !!