Date Modified Formula
I have a 2 part question:
A) Does the Date Modified field value update if a record is simply "read" during an import, ie after a CSV import occurs, you see the screen that says "500 rows read, 100 records added, 100 records modified". Would those last 300 records in this example have their Date Last Modified value change or does it only change when a substantive data change occurs?
B) if those records that are read do have their Date Last Modified value change, I'm trying to come up with a checkbox formula that says: If Date Last Modified is during the past 10 days, true, otherwise false
Essentially, I'll have a weekly automated import process, & I want to ensure any records that are included in the import are marked as active. Nothing about these records will change, the only way to determine if they're inactive is if they're no longer in one of the weekly imports. If the "read" records don't have their Date Last Modified value updated, do you have any recommendations for determining if a record is still active or not?
------------------------------
Harrison Smith
------------------------------