Frontpage database

[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!!

 

[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?

 

[scorpion53061]

I meant the starttime value

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?