Welcome to WebmasterWorld Guest from 54.167.46.29

Forum Moderators: open

Message Too Old, No Replies

Question about date & time fields for work order start and duration.

     
10:14 pm on Oct 16, 2012 (gmt 0)

Full Member

5+ Year Member

joined:June 30, 2008
posts: 318
votes: 0


hi all,

my dispatch board shows work order objects of varying start times and duration. The duration can span across hours or days. The duration is also restricted to an 8 hour work day. So, the duration for a work order that spans 1.5 days is only 12 hours.

My question is...

Is it better to define the start and duration as two datetime fields or as one start datetime field and a duration time field?

Examples:
StartDateTime[12-10-05 09:00:00], EndDateTime[12-10-06 13:00:00]
- or -
StartDateTime[12-10-05 09:00:00], Duration[12:00:00]

thanks.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members