You can use at least two of the solutions provided in this thread (Re: Yesterday's date, Re: Yesterday's date) if you simply alter the date format pattern to match your actual data. Please show the code you have and how it is failing.
In reply to Re^4: Yesterday's date
by 1nickt
in thread Yesterday's date
by jpys
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |