Recent snippets posted on Snipplr.com https://snipplr.com/ Wed, 10 Jun 2026 04:39:01 +0000 https://snipplr.com/view/66323/pivot-table-schedule <p>You have a schedule table (period, day, subject, room) with a primary key period,day to avoid duplicate bookings. You wish to display the schedule as periods, subjects and rooms in rows, and days of the week in columns.</p> Wed, 25 Jul 2012 13:43:46 UTC https://snipplr.com/view/66323/pivot-table-schedule https://snipplr.com/view/66321/age-in-years-for-given-birthdate <p>Given a birthdate in @dob, here are two simple formulae for age in years : (the second formulae is for age in years to two decimal places, ignoring day of month)</p> Wed, 25 Jul 2012 13:31:22 UTC https://snipplr.com/view/66321/age-in-years-for-given-birthdate