It seems like the biggest difference between Databases is the syntax for Date manipulation. I need to filter data based on the "end of the previous year" and the "end of the current month of the previous year". Any help would be appreciated. I have unable to locate a good source defining the syntax for the proposed date manipulation.
The Data Types and Literals manual has some useful info on this. Chaptewr 4 covers dates. A date is held internally as (yyyy-1900)mmdd in an integer. So 2009-12-17 is held as 1091217. To get last day date of the previous year, set the month and day to 1st Jan and subtract one.