... CDate(cstr(month(today.now())+1) + "/1/" + cstr(year(today.now()))) )
This idea was based on Bob Griffin's post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.