Displaying Records Greater Than a Certain Date

Followers

August 3, 200124 yr

Hi, This is my first wack at a web database. I have a list of social events. I want the web users to see only the upcoming events not any that have already happened. I have done this locally but can't seem to figure it out for the web companion. My fields are "date", "time", "location" etc. I also have a "flag" field that I use to find the needed records locally. Thanks in advance for any info.

Dan crazy.gif" border="0

August 3, 200124 yr

If you have a flag field, you could always just search on it for checked records.

- John

August 4, 200124 yr

Insert this javascript into the head portion of your page, call the showIt function on load in the body tag <body 0nLoad="showIt()"> and it put the current date and 3 dots in the date field (can be hidden). You will need to name your form.

function SystemDate(){

//current system date

var time=new Date()

var x=time

var dd=x.getDate(); (dd<10) ? dd="0"+dd : dd

var m=x.getMonth();

var yy=x.getYear();

var mm=m+1; (mm<10) ? mm="0"+mm : mm

var yyyy=yy+1900; (yyyy>3000) ? yyyy=yy : yyyy

SD= mm + "/" + dd + "/" + yyyy;

return SD

}