Greekiwi
asked on
Adding 2 hours to a value
I have a date/time field called OrderEndTime. How do I add (x) amount of hours/minutes to the value?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Script code examples to build from here:
http://www.outlookcode.com (download Sues code examples)
http://www.slovaktech.com/code_samples.htm
http://www.outlookcode.com (download Sues code examples)
http://www.slovaktech.com/code_samples.htm
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The Date() function returns the date only. Adding the time to it that way will always give you 2:30 AM.
?Date()+#2:30:00#
04/22/2009 2:30:00 AM
?NOW()+#2:30:00#
04/22/2009 3:00:40 PM
Hi jimpen, agreed just using it as a simple exaple.
Cheers, Andrew
Cheers, Andrew
ASKER
Wow, woke up this morning and already had 7 replies. All very helpful. I have given points based on which one I used.
http://www.outlookcode.com (download Sues Code examples)
http://www.slovaktech.com/code_samples.htm