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. 



Version: All
Section: SQL Scripts