SQL Needed for Dates

Summary

Calculating the later of two dates using SQL

Content

We are creating an OTBI report to figure out when to discard of hard copies of paperwork. To calculate the shred date of the papers - this is how it is determined:

1. Calculate 3 years after the associate’s hire date.
   • We have this: TIMESTAMPADD(SQL_TSI_YEAR, 3, "Worker"."Employee Hire Date")
2. Calculate 1 year after the date employment ends/term date.
   • We have this: TIMESTAMPADD(SQL_TSI_YEAR,1,"Work Relationship Details"."Actual Termination Date")
3. Whichever date is later, we can shred the individual’s paperwork on or after that date, but