I need help wiAttath simple database query. Attached database has table with date, timeout, timein fields etc. I am trying to query a list of records where datediff <=0 and also TimeDiff < -15 and if datediff =0 (which is today) then timediff must be < -15.
Actually, this is a resource scheduling database. I have timeout and timein columns are formatted to store only time value. So timediff =datediff("n", time(), [timeIN]) varies -/+ depending upon the time you run the query especially if datediff = 0.
Ultimate, goal is to run query every 15 mins, if resources are not returned after 15 mins of timeIN, display a reminder.
Hope this makes sense.
Actually, this is a resource scheduling database. I have timeout and timein columns are formatted to store only time value. So timediff =datediff("n", time(), [timeIN]) varies -/+ depending upon the time you run the query especially if datediff = 0.
Ultimate, goal is to run query every 15 mins, if resources are not returned after 15 mins of timeIN, display a reminder.
Hope this makes sense.
