HELP! Round Date

[Guest]

I am trying to figure out how to round a date to the first of the next month.

This is for calculating Insurance Benefits. I have this code in place in a
query:
Insurance: DateAdd("m",3,[DateHired]) which adds 3 months or 90 days to the
current employees hire date,

I now need it to round up the the first of the next month? Any suggestions?

 

[Pat Hartman\(MVP\)]

I posted a sample database with numerous useful date functions at this
location -
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=59781

 

[Guest]

I click the link and it says "Invalid Thead"

?

 

[Douglas J. Steele]

Try again: it worked fine for me a couple of seconds ago.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I click the link and it says "Invalid Thead"

?

I am trying to figure out how to round a date to the first of the next
month.

This is for calculating Insurance Benefits. I have this code in place in
a
query:
Insurance: DateAdd("m",3,[DateHired]) which adds 3 months or 90 days to
the
current employees hire date,

I now need it to round up the the first of the next month? Any
suggestions?

 

[Guest]

No dice, do I need to be a member perhaps? This is the message I get


vBulletin Message
No Thread specified. If you followed a valid link, please notify the webmaster

 

[John Spencer]

It worked for me also.

Did your newsreader by any chance wrap the URL onto two lines?

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=59781

The above should all be on one line.