Forum Discussion

PavB's avatar
PavB
Frequent Visitor
3 years ago

Create a Calendar Table based off values from another table

Hello, I am creating a sales report and want to create a calendar that starts with 1/1 and min year in the sales table and ends with 12/31 and max year in the sales table.  CalendarTbl = Calendar(...
Calendar Table
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi PavB 

your code shall already get what you need. you can simplify that further like:

CalendarTbl = CALENDARAUTO()  //that's all.

Or did i misunderstand you?