Multiple time frames based off item select

#1

I am trying to do a date diff formula and i need help. Lets say it has to do with aging. Products a for a 1 week, product b for 2, etc. If I have product type in column “Product” and start date in “last active”. I need “aged” column to look at “product” to get the type know how many weeks it needs to age and do a date diff from “last active” to tell me either “within min time” or “time met”. Any ideas?

0 Likes

#2

basic structure,

1st, create a table that has product names and aging times

2nd table has list of instances(ex. specific wheels of cheese), and has the date you got the wheel, has a linked field to the appropriate product type in table 1, and then use a Lookup field of the linked field to pull the aging time from table 1. You can probably do the datetime_diff() from there.


0 Likes