Tytalus,

Thanks for the quick reply, your code is giving me a format that I needed but It gave me the current month. I looking for a last date of the previous month.
Please advice.

Thank you.