How do I customize Adobe Calendars for unusual fiscal calendars? Our fiscal calendar has a specific start/end date, but no 5-4-4, 4-5-4 cadence for extra week or days.

Avatar

Avatar

jennifers536423

Avatar

jennifers536423

jennifers536423

03-01-2018

I'm trying to extract more than one month's data that aggregates the data according to our fiscal calendar, which starts each fiscal month on the 22nd and ends on the 21st, irregardless of month or year. There is no extra week appended to any year. I found how to customize the calendar under advanced settings in report builder, but if I pull more than one month, it defaults to a calendar month setting and I still have to manually run the report on the same day of each month to build out monthly reports. I can't just schedule and walk away.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

459

Correct Answer

734

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

459

Correct Answer

734
Gigazelle
Employee

10-01-2018

There are a couple ways you can do this.

In workspace, you can create custom date ranges that roll however you'd like. This is the best solution, as it allows the most flexibility.

If you're in Report Builder, you can try using date ranges from cells, then use functions to establish the correct date range. For example =MONTH(TODAY()) to get the current month, then for the day to a static number of 21 or 22.

Answers (0)