First of next month

[dglienna]

You can get the current day and also the current month. Add 1 to the month, using DateAdd(), then get the first day to use in the sql statement.