Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
nickedw0
Creator
Creator

Calendar with only a single entry per month

How can i generate a calendar which has only one entry per month. In other words I only want to have 12 entries per year.

1 Solution

Accepted Solutions
nickedw0
Creator
Creator
Author

Worked out answer:
Let vStartDate=Floor(MakeDate(2019));
Let vNumMonths = 12;

Cal:
Load TempDate as MonthDate;
Load RecNo()-1+AddMonths($(vStartDate),RecNo()) As TempDate
AutoGenerate(vNumMonths));

View solution in original post

1 Reply
nickedw0
Creator
Creator
Author

Worked out answer:
Let vStartDate=Floor(MakeDate(2019));
Let vNumMonths = 12;

Cal:
Load TempDate as MonthDate;
Load RecNo()-1+AddMonths($(vStartDate),RecNo()) As TempDate
AutoGenerate(vNumMonths));