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
Validate 1
Level 1
jennifers536423
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
jennifers536423
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
View profile
jennifers536423
Level 1

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
Affirm 500
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,948 posts

Correct reply

740 solutions
Top badges earned
Affirm 500
Boost 250
Springboard
Coach
Contributor 2
View profile

Avatar
Affirm 500
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,948 posts

Correct reply

740 solutions
Top badges earned
Affirm 500
Boost 250
Springboard
Coach
Contributor 2
View profile
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)