DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
sgray128 4/12/2018 11:30:00 AM

Function to get the fiscal period end date

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

A request came in today to create a scalar function that would accept a date parameter and return the fiscal period end date for the date provided, the code is below. 

On the way to create this, I discovered that we didn't have a 'scalar function template' on this site, so I created that too. 

http://dyndeveloper.com/ArticleView.aspx?ArticleID=2741

 

Version: All
Section: SQL Scripts