Hello and happy Tuesday,
I have been racking my brain trying to come up with a regular expression and wanted to throw this out there in case anyone has any suggestions (I'm looking at you Wayne!!!). I need to take a UK date such as 31/12/2014 and calculate the same date 4 years prior to get 31/12/2010. Basically we just want to subtract 4 from the yyyy in the dd/mm/yyyy date field. I haven't had much luck with mathematical functions within regular expressions in the past, but was hoping someone here has been successful and can offer guidance.
*BONUS POINTS if you can also provide me with a regex for the exact opposite, which will add 4 years to the yyyy in a date field instead of subtracting 4 years.