Date Function

[Chris]

I'm looking for a date function that I can use that will always just pull
the current month. Any suggestions?

Thanks,
Chris

 

[Van T. Dinh]

Month(Date())

should do it (returning 1 to 12)

 

[PC Datasheet]

Format(Month(Date()),"mmmm") will return the full name of the month; ie,
February.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

 

[John Spencer (MVP)]

Field: SomeDateField
Criteria: Between DateSerial(Year(Date()),Month(Date()),1) AND DateSerial(Year(Date()),Month(Date())+1,0)