script with variable field entry
I am trying to write a script that will first find a particular field and then perform a calculation based on the information there. The steps are basically:
Select last occupied field (X)
If (X) meets ABC criteria, perform this function
However, I can't figure out how to write the script so that it will enter the X field into the If-then statement.
Also the criteria is "Is the date in field X more than 1 year prior to todays date?" I can't figure out how to get the program to check that either. Any help would be greatly appreciated. Thank you in advance.