I need a script that queries an access database for "system" not scheduled and write the system to a text file.
The system names are CFG_01, CFG_02, CFG_03 the criteria is they can not be booked
for the current day after 5:00 pm
My fields are system, startdate, enddate, starttime, currdate
It should go something like
If system = CFG_01 and currdate >= startdate and <= enddate and endtime < 5:00 then
write cfg_01 to textfile
any help would be appreciated