Calendar

[louise119]

Would it be possible to create a calendar that is not related to the table being loaded?

[E_Røse · Accepted solution]

You can create another table with the calendar. As long as the calendar does not share any field names with the other tables, it will not be connected.

You can generate dates using the following code:

Set vFirstDate = date('01/01/2020');
Set vLastDate = date('12/31/2023');
Let vNoOfDays = $(vLastDate)-$(vFirstDate)+1;

myCal:
Load date($(vFirstDate)+rowno()) as date 
autogenerate(vNoOfDays);

The calendar can be created using derived fields of the date field, or with a new table using a resident load and date functions.

[louise119]

Thank you so much! It works!