Imput Date error.

[darkhat01]

This works:
In the Criteria box I have: Year([TARGET_DATE])=2007
This returns all the dates with the year 2007.

What I would like to do is have a box pop up and ask for the year to report for,The user would enter 1/1/2007 would be for 2007. Here is what I have tried and is does not work. The "Enter first day of year reporting" would be the test that pops up in the message box then you enter a value.

Year([TARGET_DATE])=Format([Enter first day of year reporting],"yyyy")

Thanks,

darkhat01

 

[AlexCuse]

Why not just have them enter the year? I think this would leave less room for error. I hate to rely on users to enter dates in the right formats if I can avoid it.

Something I do like to use is the calendar control, this allows the user to just click on the date they want. I use a load event for the form to select a default value in the control.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom