Hi,

Anyone have a simple solution to generate last months start and end dates ?

For example, today is 12-Nov-2003, I need 01-Oct-2003,31-Oct-2003.

If today is 01-Jan-2003, I need 01-Dec-2002,31-Dec-2002

I've got a solution but its messy i.e., tochar(todate(tochar)) etc..