Quick Question - I know there has to be an easy way to use this but I cannot seem to get the formula just right. On a saved search I want it to calculate the time between the day it was created and the date it was received (inbound shipments). I have the date created and the actual delivery date. But cannot seem to get a formula to work to tell me the days between the two.

try to_date({actualdeliverydate},'MM/DD/YYYY')-to_date({createddate},'MM/DD/YYYY')

@Yitz younger Thank You!! That worked.

ON forms that include the time portion of the date, you may need to use the ROUND function to get it to a whole number

@Yitz younger Thank you. I will keep that in mind. I was doing the round but it would give an error and not even run the report. I didnt realize I needed the date format in the formula. I have never done formulas with dates before

Here's the fun part, you don't usually need to switch to date format :)

As I am taking over more purchasing activities and as we are adding multiple locations I am finding myself using formulas alot more. So I have been learning a lot lol