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.