Fun with Time

Work time calculation

One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time

RE: Date Ranges

That doesn't handle people that arrive before 8/1/05 and depart before, on, or after 8/10/05. I'm pretty sure my previous post does the trick. If you find a hole in that, let me know. Thanks!

DateTime Conversion

I currently, have a field in a table that is a numeric field = 20030104 - I need to convert this to a date field = 01/04/2003 - what is the proper syntax for use in a select statement?Note that I am creating a table and I tried to change the field type to datetime, […]