please Help for date function

[affan]

Dear all,

Please correct me whether below code is correct or not, i need previous month in text box.

Me!BeginDate = CDate("01/" & Month(Date) & "/" & Year(Date))
Me!EndDate = DateAdd("d", -1, DateAdd("m", 1, Me!BeginDate))

Your help will be highly appreciated.

 

[RainLover]

EndDate = DateAdd("m", 1, Me.BeginDate)

The above should add I month to BeginDate and put that value into EndDate.

In order to help more I would need to know more about line one.

Please advise when this value will be calculated. e.g. Open of a Record, Adding some Data etc. Where do you get the start value.

 

[affan]

dear rainlover,

thanks for your quickly reply

Start value and end value i am using for Report. when i take report
current month , previous month

 

[namliam]

current month:
start dateserial(year(date()), Month(date()), 1)
end dateserial(year(date()), Month(date())+1, 0)
Last month
start dateserial(year(date()), Month(date())-1, 1)
end dateserial(year(date()), Month(date())+0, 0)

 

[RainLover]

dear rainlover,

thanks for your quickly reply

Start value and end value i am using for Report. when i take report
current month , previous month

So if you run the report today what would the Start and End dates be.

( For future notice ) Today is 18 January 2014.

 

[affan]

current month:
start dateserial(year(date()), Month(date()), 1)
end dateserial(year(date()), Month(date())+1, 0)
Last month
start dateserial(year(date()), Month(date())-1, 1)
end dateserial(year(date()), Month(date())+0, 0)

thank you very much sir