Tag Archives: date

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

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