>>There is also an HOUR() function, and numeric hour never exceeds 23, so you could use IF HOUR( TIME( ) ) = 23 in place of your current construct.
>
>not really - that should give function argument... invalid. Hour(Datetime()) much better ;-)
Good catch... the one time I post w/o testing :(
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up