First date of month

S

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.
 
S

Sunny

Found it!

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

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
 
Top