Date question 2

[kpryan]

Hi all,
If a date format is used ie; yyyy which returns 2008 how can a date range show 2007 - 2008, so that the dates will follow every successive year. Does the code for a form work for a report as well?

Ken

 

[Remou]

Do you want:

Between Year(Date) and Year(Date)-1

A form can be based on a query as can a report.

 

[load3d]

I have a form that is based on a query where I'm showing appointments created in the last year. This is the selection criteria in my query.

CDate([datefield]) where >=DateAdd("Y",-1,Now())



Hope this helps.

 

[PHV]

Use this criteria:
>=DateAdd("YYYY",-1,Now())

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886