In this particular example, Date() would make more sense - who cares what time the work order was issued, in my application some of the numbered reports refer to when a truck is unloaded or loaded. Having the time logged gives a reference that allows management to be able to review video logs if they suspect someone is playing 'games' with inventory. It also allows management to calculate how long it takes to unload or load a truck (start time is logged when the work order is selected to be processed) The work order is the primary key to the entire process and each step on the way to completion is logged and reported. The initial work order number will have Date() and the final completion report will have Date(), everything in between will be Now()

Nice sample db - I like the way you addressed error conditions