He everyone,

I am having a problem with a search facility that will display records from a search option. a section of the search criteria is Date From - Date To

I have set these up as select boxes for dayfrom, monthfrom, yearfrom and the same for the dayto, monthto, yearto

Once the form is submitted i merge into DateTo & DateFrom variables.

Now i have 2 compariable days which will be valid.

I then use them is a betwen sql statement

Opp.OppPublished BETWEEN #"&DateFrom&"# AND #"&DateTo&"#

The only problem is that if they pick a day eg 31/4/2004

it crashes my sql statement because april has only got 30 days. But i need the 31 there for other months.

How can i round down the day to a valid day for the month without lengthy control structures?

Thanks

Tim

TDA

__________________
TDA

Hi Tim,

You may want to change to popup calanders or datepickers using javascript to solve this. Else you would have to check for a condition if Month is so and so and based on that you should populate the Days select list.

You can take a look at these scripts. Easy to copy paste and intergrate with your application.

Date Selector - Should be the right one in your case.

Date picker

You can also search for date pickers, you would get a lot of such stuff over the net.

Hope that helps.
Cheers!

_________________________
-Vijay G
Strive for Perfection

Thanks,

Works perfectly.


TIM :D

TDA