There is an interesting task: to compare time periods.
Scenario: there are two tables, both of which indicate the validity period of the promo code. The period is expressed as a start and end date. Tables are linked by relations that track changes in rows. The problem is that if the date is stored not as a number, but as a date, then months cannot be compared.
How can you compare dates and show the results to the user with a spread of + or - 2 days?
I only see a solution if the date and the first table is split into separate cells and stored as a number.
What solution do you see?