Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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.

jennifers536423
Level 1
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
Gigazelle
Correct answer by
Employee
Employee

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
Gigazelle
Correct answer by
Employee
Employee

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