criteria with start date as month and year

[louise]

Hello,
I need to specify a criteria in my query that sets the beginning of the date range as greater than/equal to a (constant) month (9, Sept -- always Sept.) and then prompts for the beginning year. The end of the date range is the present (Date() ) For example, to include all records after 9/1/ ...[enter the year].

I have tried various DatePart approaches, but everything I try results in limiting the months for all subsequent years as well. Whereas I want the entire year after that starting point. And, I am not able to set the parameter right into the date, >=#9/1/[What Year?]#



My field is ExpirationDate, a time/date field.

Any help would be much appreciated!

[cyanidem]

Try >=CDate("09/01/" & [What year?])

[louise]

Hi,
Thank you so much! I didn't know about the CDate function. I'm sure it will be useful in the future.
Can you now give me a lead on how to insert that "chosen" [What Year?] into a text box in the header of the report?
Thanks

[June7]

I NEVER use dynamic parameter popups in query - can't validate the input.

Better to use a form for the input. Then the report can reference the form control as parameter input:

>=CDate("9/1/" & Forms!formname!controlname)

And textbox on report can have expression: =CDate("9/1/" & Forms!formname!controlname)