Pulling Year from system

[cbende2]

Hello all,

I'm trying to get a date #1/1/2014# to pull the year from Now()

Here is my code:

DCount("Field1", "Table1", "[Field1] Between #1/1/2014# And #1/8/2014#")

I would really like for something like this:

DCount("Field1", "Table1", "[Field1] Between #1/1/Year(Now())# And #1/8/Year(Now()#")

However the bottom code does not work. Can anyone steer me in the right direction?

Thanks

[cbende2]

Can a mod move this post to General Access forum?

I was looking through forms section and accidentally posted here.

Thank you

[pbaldy]

Thread moved. Check out the DateSerial() function.

[cbende2]

Thanks for moving thread, and Ok I'll give it a look. I'll get back to you.

[cbende2]

Well, I'm not getting any errors, but it isn't returning the correct count either.. It's returning 0 when it should be returning 4.

[pbaldy]

What did you try exactly? I had in mind using DateSerial for each of the dates, probably concatenated into the string, though that may not be necessary.

[cbende2]

Nevermind, my dates in my table are 2014, so I just needed to "-1"

It's working now, thanks paul.

[pbaldy]

No problemo!