Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

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

Level 1

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.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Employee Advisor

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.