Finding complete records older than 'X' months
FMPro10 & FMPro11, FM Server11. Windows Network (XP & Vista). db built on Pro10.
I want to start archiving records where the dispatch date is older than a set amount of months (3~12)
I have a field [ADMIN::record_archive_threshold] that has a value list selection of 3~12
I want to use this value in a calculation for the find, but am getting inconsistant results. I currently have:
Enter Find Mode [ ]
Insert Calculated Result [ Date ( Month ( Get ( CurrentDate ) ) - ADMIN::record_archive_threshold ; Day ( Get ( CurrentDate ) ) ; Year ( Get ( CurrentDate ) ) ) & "..." & Get ( CurrentDate ) ]
Perform Find [ ]
Show Omitted Only
I think I have overcomplicated it a little, does anyone have any better ways of doing this?