AnsweredAssumed Answered

Finding complete records older than 'X' months

Question asked by david583 on Jun 14, 2011
Latest reply on Jun 15, 2011 by david583

Title

Finding complete records older than 'X' months

Post

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?

Outcomes