I need to be able to identify any gaps between dates, for example:
Start Date - End Date
01/01/2015 - 31/12/2015
01/01/2017 - 31/12/2017
01/01/2018 - 31/12/2018
I need my bot to be able to identify the gap above (for 2016) and return the date range of 01/01/2016 - 31/12/2016 as two string variables.
How can I do this? Thanks in advance!