I created a report layout that allows someone to select dates from a drop down menus. There are 2 menus for the "From" date and 2 menus for the "To" date.

The first menu (Value List)of the "From" choice allows them to select 01/01/, 02/01/, 03/01/ etc., the second (Value List) allows them to select 2003, 2004, 2005, etc.

The first menu of the "To" list allows them to select 01/31/, 02/28, 03/31, etc and the second 2003, 2004, 2005.

I have a set field in a script that combines the 2 drop down choices to arrive at the "From" date and combines the other 2 for the "To" date. Everything is working correctly except for the month of November. Part of the script also combines the "From" date and the "To" date for a search so, for example, it inserts 03/01/2003...06/30/2003 into a date field and performs a find.

The script takes the user to a report layout that displys

From 03/01/2003

To 06/30/2003

23 residents borrowed

42 tools from the center

Any month I select appears correctly in the report except if the From date is 11/01/2003. When selecting 11/01/2003 even the To date doesn't appear in the report. If I select 10/01/2003 and the same To date that hadn't appeared it now displays because the From date isn't 11/01/2003.

I can't get this to work. Why doesn't one value in a value list not appear correctly when the others do. Does it have something to do with it being the current month will 12/01/2003 not work next month.

I even changed the Value List to 111/01/2003 and I get the message its not valid do I want to modify the find, if I cancel the From field appears as

From 111/01/2003 so I know the script is working.

Any body have any ideas?

Maria

Hi, Maria ...

There is nothing inherently weird about the date 11/01/2003. I had no problem getting all date ranges to work in the attached demo.

I suspect there is a glitch in one of your value lists and/or in one of your calculations. Maybe there is an errant invisible character entered in the "from month" value list. Try re-entering the values and see if that helps.

I almost always discover that when something doesn't work as expected, I've made some kind of little error that trips up what I'm trying to do.

Good luck!

From_To_Dates.zip

Also, make sure you didn't accidentally use the letter "O" instead of the digit "0".