Nasty date question

May 30, 200124 yr

Hi,

I think this is gonna be a nasty one. Using filemaker 4.1, in a database

I've two date fields, data_start and date_end. I use a website for our users

to access this database to have a look in the planning of radiostation, I

want them to be able to search on items running on a date they enter.

I allready do it in FM itself, by running a simple script, but that's no

solution to the web. Now I figured out I could create a textfield containing

all dates from date_start 'till date_end. So, by searching on that

textfield, FM comes up with all records 'running' on the requested date. The

question is : how.......

If anybody could help ??

Cheers,

Andr

May 30, 200124 yr

Not a problem. The solution is to do a compound search of both the date_start and date_end fields. You want to take the search date and search for 'date_start...' and '...date_end'. The easiest way to take a single date entered on a form and place it in 2 fields for the search is javascript.

Here's a quick stab at what you'll want in your page:

<head>

function setDates(){

document.search.date_start.value=document.search.search.value+"...";

document.search.date_end.value="..."+document.search.search.value

}

</script>

</head>

<body>

Search date: <input type="text" name="search" value="" size=10>

</form>

<body>