First date of month

[Sunny]

Ho do I find first day of given month or first day of next month?

e.g for 11/14/2003 -> 11/1/2003 (first day of current month) and 12/1/2003
(first day of next month)?

Thanks.

 

[Sunny]

Found it!

date - datepart("d",date) + 1
and
dateadd("m",1,date - datepart("d",date) + 1)

 

[May]

Try the DateSerial Function.
DateSerial(YEAR(anydate) , Month(anydate), 1)
DateSerial(YEAR(anydate) , Month(anydate)+1, 1)

May
MCP in Access and SQL Server