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 · Accepted solution]

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

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