Add months with last day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to use the DateAdd command on adding months.

DateAdd("m", 45, ThisDate) However I need to insert the last day of the
month.

6/2/05 + 45 = 3/3/09 I need the answer to be 3/31/09.

Any Help is Appreciated

Granny
 
Try something like:
DateSerial(Year(DateAdd("m", 45, ThisDate) ), Month(DateAdd("m", 45,
ThisDate) )+1,0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converted from LINUX time ok, but having issues with the between date. 4
Help with small result type 2
Show data between the first and last day of the previous months 0
Fiscal Year Query 1
Add a day and a month with DateAdd 4
DateAdd and Date Format at once 6
Find first day of last month 4
Pull latest date from Multiple entries 2

Back
Top