last 12 month data

[MarkP]

Here’s the thread for Teradata relative dates:

120×120 10.4 KB

To add to the existing Oracle and SQL Server lists, here are my versions of the Teradata equivalents. Perhaps after any discussion and validation, they can be added to the same ‘Sticky’: Yesterday: DATE-1 Today: DATE Start of Current Month: (DATE - DAYOFMONTH(DATE))+1 End of Current Month: ADD_MONTHS((DATE - DAYOFMONTH(DATE))+1,1)-1 Start of Previous Month: ADD_MONTHS((DATE - DAYOFMONTH(DATE))+1,-1) End of Previous Month: (DATE - DAYOFMONTH(DATE)) Start of Current Quarter: CASE WHEN MONT…