Tag Archives: date

Show Full Name of Editor and Date of Edit for Resources in MODX

A MODX user asked for a way to show the full name of the last person to edit the current page, or nothing at all if the page had never …

Tags: , , , , , , , , , , , , , , | Posted under MODX, MODX | 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

Populate SQL Table with All Valid Dates Between Two Periods

I am working on a request from a client that required the use of a date table, but not just any date table. This table had some additional requirements; 1. …

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