This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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(May4th?)" is the fiscal month end always the 4th day of following month?
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.
Results, scrolled to show how Feb 01 and 02 are in Fiscal Jan
The work flow only does one year at a time because of the the initial start date. You can either convert it to a macro and run it dynamically or run it for the next 20 years and store the results in a .yxdb.
Note that your example db only had the Week ending dates in it, so I added a generate rows tool called "Input days" to generate more sample data.