Create Dates from Year

[MK9885]

Hello,

I  would like to create dates out of Year.

I do not have Date field, no Month field but just Year Field.

I used MakeDate function and it just generate 4 dates for me

I've years from 2014 to 2017

and I want dates for each month for these years....

01/01/2014 till 12/31/2017

neelamsaroha1575‌

stalwar1‌

Thanks.

[Anil_Babu_Samineni]

FYI - This won't generate till 31-12-2017. For that you have to use YearEnd() function where i mentioned first post

[MK9885]

Ok,

so it will be

tabCalendar:

LOAD *,

     Week(Date) as Week,

     Month(Date) as Month,

     Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter,

     Year(Date) as Year  

LOAD Date(MinDate+IterNo()-1) as Date

While MinDate+IterNo()-1 <= MaxDate;

LOAD YearEnd(MakeDate(2017)) as MaxDate,

     Now() as MaxDate

AutoGenerate 1;

Is that correct?