Let's say you havea list of dates in one column showing when a client subscribed, and another column that shows how many months until the subscription ends.
You're wanting to see what the actual date will be on the day the subscription ends. HOW CAN YOU ADD THE NUMBER OF MONTHS TO THE DATE?
Normally if you’re wanting to add a certain number of months to a date you would just use the DATE function and use something like (column_name,’+4 months’), but you can’t do that here since each row has a different amount of months.
As a workaround you can use the following SQL to add everything up.
Et voila! You are now the master of dates.
Please sign in to leave a comment.