http://snipplr.com/users/cahyadsn Recent snippets posted on Snipplr.com en-us Sun, 19 May 2013 13:59:55 GMT http://snipplr.com/view/66323/pivot-table-schedule/ 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.

]]> Wed, 25 Jul 2012 13:43:46 GMT http://snipplr.com/view/66323/pivot-table-schedule/ http://snipplr.com/view/66321/age-in-years-for-given-birthdate/ 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)

]]> Wed, 25 Jul 2012 13:31:22 GMT http://snipplr.com/view/66321/age-in-years-for-given-birthdate/