dateofaction - string - form at is 6/12/2004 11:00PM (obtained from SQL as the time is is right now)
jobstreamstart - datetime - 11:00:00PM (Obtained from SQL)
jobstreamend -datetime(SQL) - 3:00:00AM (obtained from SQL
We need to devise a function or if...then to detect if dateofaction is later than the jobstreambegin and earlier than the jobstreamend.
It would be nice to be able to handle timezone issues. But not a necessity.
Thank You Much.