Nasty date question

arotgans · May 30, 2001

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

dspires · May 30, 2001

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>

Sign In

Nasty date question

Recommended Posts

arotgans

dspires

Create an account or sign in to comment

Create an account

Sign in

Browse

Site Support

Forums

Blogs

Marketplace

Activity

Important Information