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?
Page 1 / 1
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.

Linked record fields
A linked record field allows you to represent the relationships between related records by creating links between them. This is particularly helpful when you have multiple tables of related items o...
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.