Date and Time Manipulation
Calculate Easter Sunday Date - Most holiday days have fairly simple formulae. Easter Sunday is different and really requires a function of its own.
Create Master Calendar Table - A daily calendar table with a huge number or pre-calculated calendar attributes, plus most North American Holidays.
Time Zone Storage and Conversion - 3 functions and a table to facilitate easy conversion of a date and time between time zones. Includes provisions for DST.
Date Ceiling Function - Rounds a date time up to the next whole second, minute, hour, day, month or year, as required
Date Floor Function - Rounds a date time down to the last whole second, minute, hour, day, month or year, as required
Format DATETIME as String - Changes a DATETIME parameter to the format 'Fri 22nd Jun 2012'.
Convert Milliseconds to Hours and Minutes String - Converts #Milliseconds to a string of format '0000h 00m'.
Calculate Common Date Ranges - A function to calculate the start and end dates for common date ranges e.g. This Week, Last Month, Next Year
Grouping/Counting by Dates - Examples of a simple technique for easy grouping of dates by second, minute, hour or day (and some points in between).
Generate Date Ranges - Examples of techniques used to generate sequential or random date or date/time sequences.
Get Fiscal Year Ordered Month List - Order the list of months from April to March, representing a fiscal year.