Marking Inventory as Carry Over

[dkbollig]

So I've been offered a challenge to be able to mark inventory as "carry over" based on how old it is from our sales calendar which is September 1st.

So lets say we order a product and capture its order date on November 18th 2013 I somehow have to add logic that once a date passes Sept 1st 2014 that ordered product is now considered carry over.

I've been thinking some formula that subtracts the days from September 1st to the Order Date but not sure if that's the right direction.

Any ideas?

Thanks!
Derek

 

[Latchmaker]

=if("CurrentDate"-"Orderdate">"#ofDaysOldtobeconsideredCarryOver","Carry Over","")

The above formula with References change to match your data will return "Carry Over" if the # of Days Old has exceeded your Carry Over Criteria it will return a blank until it meets the Carry Over Criteria

The formula could be modified to show #ofDays until Carry Over instead of Blank by replacing ,"") with concatenate("Days Until Carry Over","("CurrentCate"-"OrderDate"-"CarryOverCriteriaInDays")")