Adding Time

neilhead
07-21-2003, 03:45 AM
I have a textbox with a time as Now function, how can I make sure if someone wants to alter the time (as it could be a start tiem) that it is entered as hh:mm:ss and allows nothing else?
Also, if I have another text box that has an amount of time in seconds (e.g. 7200), how can I add the start time to this amount and show the new time? e.g. Start time = 15:30:10, 7200 secs pass, finish time = 17:30:10?

pradeep
07-21-2003, 03:49 AM
DateAdd("s", 7200, "15:30:10")

SpaceFrog
07-21-2003, 04:00 AM
To ensure correct format for date entry, I would use three textboxes or labels associated to updown controls, or a chencking procedure on keypress or change events...
For adding, rpely has been given !

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum