Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Comparing Time elements of dates
[b][red]This message was edited by anrice at 2004-3-15 7:49:1[/red][/b][hr]
I want to check the time element of a date entered against the
a field that stores the Working Day Start Time to see if the time element of the date entered precedes or is after the Day Start Time.
I can currently do this using datediff and playing around with date calculations but what is the easiest way to do so?
The code I am currently using is along the lines of:
as dec (7,5)
= '14:00', @dat_to
= '15-mar-2004 13:15'