Points: 54175

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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables