Function

[Will Peterson]

Hi Everyone,

Wrote a function and I keep getting this in the field:
#Name?

Version
2000

Funtion
Function FirstOfNextMonth()
FirstOfNextMonth = DateSerial(Year(Now), Month(Now) + 1, 1)
End Function

Pls hlp,

Thanks-In-Advance
WP

 

[Lynn Trapp]

You may hav some reference that is broken or missing.

 

[Ernie]

Doesn't the "Now" function require the () to work?

So your function should read:

FirstOfNextMonth = DateSerial(Year(Now()), Month(Now()) +
1, 1)


I could be wrong.