Tag Archives: finding

Finding Week Number in SQL Based on Fiscal Period

If your fiscal year matches the calendar year then SQL has an easy process of find the week number. You simply use something like this:

Tags: , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Finding Date Closest to Middle or Last Day of Month in SQL

If you have ever worked in SQL or other databases you know that dates can be very tricky. It is not always simple to capture differences and length of time …

Tags: , , , , , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Spelunking in the MODX Codebase

There are times when the MODX docs just won’t tell you what you need to know. You have to look at the relevant code itself. Before you can do that, …

Tags: , , , | Posted under MODX, MODX | Leave a comment