current date, calculate one moth back intit and end date

[sal21]

I need to a function to calculte the first and last date of one month back based current date...example:

now is 13/10/2010

calculate the first day and the last day of one month back, in this case is september.

first_day =01/09/2010
last_day=30/09/2010

note:
in vb6 classic
tks.

[mbarron]

First day of previous month:
DateSerial(Year(Date), Month(Date) - 1, 1)

Last day of previous month:
Date - Day(Date)

[HansV]

Let's say that your date is stored in a variable MyDate.

The first of the previous month is DateSerial(Year(MyDate), Month(MyDate) - 1, 1)
The last of the previous month is DateSerial(Year(MyDate), Month(MyDate), 0)

[sal21]

Let's say that your date is stored in a variable MyDate.

The first of the previous month is DateSerial(Year(MyDate), Month(MyDate) - 1, 1)
The last of the previous month is DateSerial(Year(MyDate), Month(MyDate), 0)

tks for sugestion!

[sal21]

First day of previous month:
DateSerial(Year(Date), Month(Date) - 1, 1)

Last day of previous month:
Date - Day(Date)

Tks!