Tag Archives: date

Using PIVOT on Dates in One Column

Suppose you have a table that contains Job ID, when it was started, and when the Job ended. Now you want the difference in days between when it was started …

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

Making ‘News’ Page with Addons in SilverStripe CMS Part 1

To show news on frontpage, you need to make the News pagetype and holder for it. In this and the next post, I’m going to tell you how to make …

Tags: , , , , , , , , , , , , , , | Posted under SilverStripe CMS | Leave a comment

Displaying MODX Date Fields

As a person who used to write code that had to run in 64K of memory, the way MODX date strings are sometimes handled has always disturbed me. I’m calling …

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