Add an integer column to a date?

cmnflom

I have two columns, one is the report_date and the other is days_of_inventory.

I am trying to add the days_of_inventory to the report_date column which is in date format. I have tried using the following formula, but it is not creating the output I am looking for:

ToDate(report_date + days_of_inventory)

How can I fix the above formula? Thank you in advance!

Luke_C

Are you trying to add days to the report date? If so:

datetimeadd([report_date],[days_of_inventory],"days")