Formula in query adding hours to date for new date

ssblue
ssblue used Ask the Experts™
on
Access:  I need to add a "Interval" to a date, in a query.   I have a field labeled "Start_Date" / Date/Time   and a field labeled "Interval"/Number
The field interval is in hours.

I need to add the intervals to the start date for a NEW start date.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ResQTek NancyPresident @ ResQTek

Commented:
Just stabbing at this, as I haven't used Access in a while. :)

YourNewDate = DateAdd ( interval, number, date )

https://support.office.com/en-us/article/dateadd-function-63befdf6-1ffa-4357-9424-61e8c57afc19
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
in a select query, you would do something like:

SELECT [Start_Date], DateAdd("h", [Interval], [Start_Date]) as NewStartDate
FROM yourTable
ssblueCoordinator

Author

Commented:
Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial