Return the date for the first Saturday in December of the current year

[jmclemor]

Hello,



I'm very rusty in my Access skills (haven't been using Access for many years) but am working on a database now where I need to pull the date of the first Saturday of December for the current year. I am using this as criteria in a query and so I really need this using the DateSerial() function if possible.

Here's what I have that is NOT working correctly:

=DateSerial(Year(Date()),12,Day(DateSerial(Year(Da te()),12,WeekDay(12/01/Year(Date()), 7))))

Thanks so much for any help you can provide. I'll be in your debt!

[rzw0wr]

Try, DateSerial(2013,12,7)

Dale

[pbaldy]

Try, DateSerial(2013,12,7)

I think the point is to pull it dynamically. Try this, tested in the Immediate window

?DateSerial(Year(date()), 12, 0) + (8 - WeekDay(DateSerial(Year(date()), 12, 0), 7))
12/7/2013

[rzw0wr]

Well that makes sense, pbaldy.

I was wondering.

Dale

[jmclemor]

Works exactly as needed! Thanks so very much.

And thanks rzw0wr for your help as well.

[pbaldy]

Happy to help, and welcome to the site by the way!

[jmclemor]

Thanks! I appreciate the welcome, pbaldy.