Woah! This is a biggie.
So there are fourteen fields, yes? One for opening time and one for closing time for each day of the week. (I don't even want to think about holidays!! )
So the script would have to figure out which day of the week it is before it even knew which field to search on.
I think you would need to enter your times as four-digit numbers -- 0000 to 2359. The script could then convert the current time to a four-digit number for comparison purposes. For days when the organization was closed, you would need to enter -1 in both fields. And the fields would have to be field type "numer."
And all of this would have to be done in sub query.
Yeah, I think it can be done, if the fields are set up the way I described above.
I do want to make sure this is what you want before I start writing code.
JPD
http://www.jpdeni.com/dbman/
So there are fourteen fields, yes? One for opening time and one for closing time for each day of the week. (I don't even want to think about holidays!! )
So the script would have to figure out which day of the week it is before it even knew which field to search on.
I think you would need to enter your times as four-digit numbers -- 0000 to 2359. The script could then convert the current time to a four-digit number for comparison purposes. For days when the organization was closed, you would need to enter -1 in both fields. And the fields would have to be field type "numer."
And all of this would have to be done in sub query.
Yeah, I think it can be done, if the fields are set up the way I described above.
I do want to make sure this is what you want before I start writing code.
JPD
http://www.jpdeni.com/dbman/