Calculate a future date

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

Guest

I'm trying to take the date stored in INVDATE and calculate COVDATE. The
COVDATE is simply the first day of the next month.

So, if INVDATE is 3/5/2007, then COVDATE is 4/1/2007. If INVDATE is
12/15/2007, then COVDATE is 1/1/2008.

I was playing around with this function
DateSerial(Year([InvDate]),Month([InvDate]+1),1), but no luck thus far.
 
Kirk,

almost had it. Instead of:

DateSerial(Year([InvDate]),Month([InvDate]+1),1),

try:

DateSerial(Year([InvDate]),Month([InvDate])+1,1),

You put the right paren in the wrong place for the Month portion.

What are you getting?
 
Your function works perfectly. Thanks!

Dale Fye said:
Kirk,

almost had it. Instead of:

DateSerial(Year([InvDate]),Month([InvDate]+1),1),

try:

DateSerial(Year([InvDate]),Month([InvDate])+1,1),

You put the right paren in the wrong place for the Month portion.

What are you getting?

--
Email address is not valid.
Please reply to newsgroup only.


Kirk P. said:
I'm trying to take the date stored in INVDATE and calculate COVDATE. The
COVDATE is simply the first day of the next month.

So, if INVDATE is 3/5/2007, then COVDATE is 4/1/2007. If INVDATE is
12/15/2007, then COVDATE is 1/1/2008.

I was playing around with this function
DateSerial(Year([InvDate]),Month([InvDate]+1),1), but no luck thus far.
Click to expand...
Click to expand...
 
Back
Top