Link to home
Create AccountLog in
Avatar of error_prone
error_prone

asked on

Formula for Next Month Not Using DateSerial

Can I get formulas that will give me the first of next month and the first of the month after that not using the DateSerial function?  I'm using MS Query and it does not recognize the DateSerial function.  So it would be
>= #1/1/2010# And
< #2/1/2010#
ASKER CERTIFIED SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of error_prone
error_prone

ASKER

MS Query was erroring out in this formula:
DateSerial(Year(Date()),Month(Date())+1,1)

It seems to be converting the 1 at the end to a weird date.