HELP: Date Extraction

T

Tim

I have a form that contains a list of dates, and I only want to show the
dates that are from the current year.
 
G

GPO

If it is just a transient desire to do this then right click on the field
and in the option "Filter for" enter >=#1 Janary 2005#
If you always want your form to only show the current year's data, base the
form on a query that includes a WHERE clause like

WHERE [TheDateFieldWhoseNameIDoNotKnow] >= cdate("1 January " &
Year(Date()))

GPO
 
Top