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!
Solved! Go to Solution.
Are you trying to add days to the report date? If so:
datetimeadd([report_date],[days_of_inventory],"days")