Our datadbase holds Date information that must be updated every 24:01. + 1 day
I want to have a warning on our internal web (ASP VB Script)page that gives a graphical warning that the date field have not been updated.
Simple query returns any boats that have a PositionDate entry today, its A text field.
SELECT *
FROM Boats INNER JOIN position ON Boats.HMSTC = position.BoatName
WHERE Boats.PostionDate=Date()
I need a piece of script that says that if there is no entry today, see if there is one for the day before and if so flag up an img showing a red cross, also if there is an entry for today then show a green tick img.
Ive no idea how to do this &
Help ?
Many Thanks
Start Free Trial
