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
BedrockMission!

Learn More

View all

Sign in to view all badges

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
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
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)