Date

R

Roblip

I have created an invoice where I put in the date of the
month as the first (5/1/YYYY). It works find until
January of the following year. DateSerial(year(Now
()),Month[ActivityDate])+1,1). Every date is correct
except the one for January, it comes out as January 1 of
the year after (from December 1, 2000 to January 1, 2002).
I figure I am adding 13 and that's why but if you know
another answer, thanks. Now I just change the year(Now
part to the year minus -1 and it works.
Thanks.
 
Top