How do I get fiscal month end date for a regular calendar date?

I'm trying to get the fiscal month end date for dates out of an SAP table. For example, for 4/5/2019 the fiscal period end date is 5/4/2019. I can see how to get month end, but that doesn't work for what I need. I was able to get week ending date and those dates are below as an example of what I'm working with.

Example.yxdb

Date Time

Accepted answers

danilang

New WF with a small modification. The original returned the fiscal month but not the end date of the fiscal month

Dan

Fiscal Month v2.yxmd

All comments

danilang

Hi there @tlkirby

Can you provide a more detailed formula to calculate the fiscal month end, preferable with a few, unambiguous examples. In your example, "4/5/2019(5th of April?) the fiscal period end date is 5/4/2019(May 4th?)" is the fiscal month end always the 4th day of following month?

Dan

tlkirby

Hi! Our fiscal calendar is set up January through December. January has 5 weeks, February and March have 4 and the months repeat in that format. The last day of January 2019 is Feb 2, February 2019 last day is March 2, March 2019 last day is March 30, and so forth following the 5/4/4 format. Since there is not a specific date that ends the month, this might not be possible.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703