Query part of date

[696796]

I want a pop up box to appear for the user, so they can type in the year of a date.

I have this which doesn't work

DatePart("yyyy",[OrderDate])

the format of my date in the table is

26/07/2002

I just want to search on the year basically.

Any ideas??

Thanks

 

[melaniecarr23]

Where do you want the popup box to appear?

If you are using a query and would like it to generate a popup box asking for the year, you could use ["Enter year"] in the criteria section for the OrderDate field.

Does that answer the question, or were you trying to do something else?

 

[PHV]

Something like this ?
WHERE Year([OrderDate]) = [Enter Year]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[696796]

The thing is I just want the user to enter the year i.e. "2002" as apposed to 16/06/2002

 

[melaniecarr23]

Why don't you create an expression field, for example:
ExprYear: DatePart("yyyy",[OrderDate])

Then enter the criteria for ExprYear as ["Enter date"]

Would that work?