Dates

[SteveHirsch]

Can anyone help with a query that takes the dates (with other data) and convert to monthly?

 

[selenau837]

Can you please be a little more specific with your question?

DatePart() function may be what you are looking for, but I am not sure.

 

[nateobot]

We can't help if you don't tell us what you need help with. Post the query and tell us what isn't working/what you are looking for.

Extracting a month from a date field is not difficult, but I am not sure if that is what you want.

SELECT Month([datefield]) AS [DateMonth]
FROM Table1

 

[namliam]

I would suggest that if you dates go over a period of years you cannot use datepart or month

You should then do
Year([Yourdate]) & Month([Yourdate])
or
Format([Yourdate],"YYYYMM")

Seasons greetings from Amsterdam

The Mailman