ssblue
asked on
Formula in query adding hours to date for new date
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.
The field interval is in hours.
I need to add the intervals to the start date for a NEW start date.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
YourNewDate = DateAdd ( interval, number, date )
https://support.office.com/en-us/article/dateadd-function-63befdf6-1ffa-4357-9424-61e8c57afc19