First day of month 1

[pjtarheel]

Hey,

How do I get a query to return the first day of the month for a given date? I've got a membership table with member start dates that land on all days of the month, and I want to group them all by the first day of the month. Has to be the first day because we have other tables where the member dates all fall on the first, so all reports are set up around that.

Thanks!

Paul

 

[SkipVought]

Hi,

whatever your date field...
[tt]
dateserial(year([datefield]), month([datefield]), 1)
[/tt]


Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]

 

[pjtarheel]

Perfect! Thanks! I have searched far and wide for how to do this. This website is great!