I have a database of journal entries with dates, which I would like to group by year, like so:
The problem is, I don’t actually have a year column – just a timestamp. Is there a way to pull the year from the timestamp and group by that? I’ve been using an array to do it, but every time I add a year I have to edit the code to add the new year in.
Michelle, wife & homeschooling mommy to 4
The Mommy Database – #!/usr/bin/mom
if at first you don’t succeed, try, try again. then quit. no use being a damn fool about things.
– w. c. fields