Link to home
Start Free TrialLog in
Avatar of ssblue
ssblueFlag for United States of America

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.
Avatar of Nancy Rindone
Nancy Rindone
Flag of United States of America image

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
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ssblue

ASKER

Thanks!