first day of the next month

[2bulent2]

hello

i need to print the first day of the next month in a report

today is 10.08.2009(d.m.y)
it will write 01.09.2009 automatically
?

 

[alvechurchdata]

Start by getting the first of this month, then use DateAdd to add one month to that date:

todaysDate = date()
firstThis = dateserial(year(todaysDate), month(todaysDate), 1)
firstNext = dateadd("m", 1, firstThis)

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[PHV]

=DateSerial(Year(Date()),1+Month(Date()),1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[alvechurchdata]

=DateSerial(Year(Date()),1+Month(Date()),1)

Very neat. At first I though that this would fail at 31st December but, after a little testing, I now know that DateSerial() will accept a month of 13 and will increment the year.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[2bulent2]

thanks