Frontpage database

S

scorpion53061

Hi how do I tell the Frontpage database results not to display any entry
date that is older than than today?

Thank you much for your help!!
 
S

scorpion53061

That is solved by:

SELECT DateOfEvent, EventName, Location, StartTime FROM Events where
DateOfEvent >= Date() ORDER BY DateOfEvent, StartTime

How do I make the :00 drop off the date at the end of the date value?
 
S

scorpion53061

I meant the starttime value

scorpion53061 said:
That is solved by:

SELECT DateOfEvent, EventName, Location, StartTime FROM Events where
DateOfEvent >= Date() ORDER BY DateOfEvent, StartTime

How do I make the :00 drop off the date at the end of the date value?
Click to expand...
 
Top