DateSerial Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DD - 29 May 2006 19:38 GMT

Good Afternoon,

I have inherited an Access database and it contains the following
formula on a date field:

Between DateSerial(DatePart("yyyy",Date()),DatePart("m",Date())-2,1)
And Date()-(DatePart("d",Date()))

I believe this pulls data for the past two months, but I'm not clear on
how the entire functions works.

I would like to use the same formula and pull last 6 months of data,
can use the same formula but change the -2 to a -6?

Any information would be appreciated.

Thanks

Reply to this Message

Ken Snell (MVP) - 29 May 2006 22:10 GMT

Did you try making the change to -6? That should work for you. See
DateSerial function in Help file for more information about it.

Signature

Ken Snell
<MS ACCESS MVP>

> Good Afternoon,
>
[quoted text clipped - 13 lines]
>
> Thanks

Reply to this Message

DD - 31 May 2006 17:22 GMT

Thank you - that worked.

> Good Afternoon,
>
[quoted text clipped - 13 lines]
>
> Thanks

Reply to this Message