HELP! Round Date

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

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?
 
Try again: it worked fine for me a couple of seconds ago.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Johanna said:
I click the link and it says "Invalid Thead"

?


Johanna said:
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?
Click to expand...
Click to expand...
 
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
 
Back
Top