I have a table that is used to remember how often certain weights need to be recalibrated.
The table has a field to show the date_of_last_calibration (LastCalDT) and a field to show calibration_interval (CalIntrvl).
CalIntrvl can be 365, 730 ect.
I can use <date()-365 to list all the ones that have gone past 365 days without recalibration but I want to replace 365 with the CalIntrvl for each record (or weight). Thanks, GGuy
The table has a field to show the date_of_last_calibration (LastCalDT) and a field to show calibration_interval (CalIntrvl).
CalIntrvl can be 365, 730 ect.
I can use <date()-365 to list all the ones that have gone past 365 days without recalibration but I want to replace 365 with the CalIntrvl for each record (or weight). Thanks, GGuy