Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2007
    Posts
    2

    Unanswered: help.. date find request

    i need to perform a find on records that are older than 30 days.
    i have been changing the date everyday ie<=7/14/2007), but i would like for the find to find all records older than 30 days compared to todays date.
    thx.

  2. #2
    Join Date
    Aug 2005
    Location
    Minneapolis, MN
    Posts
    56
    Use a script to perform the calculated find.

  3. #3
    Join Date
    Aug 2007
    Posts
    2
    I need help with the calculation

  4. #4
    Join Date
    Aug 2005
    Location
    Minneapolis, MN
    Posts
    56
    For FM7 and later, try:

    Enter Find Mode[]
    Set Field [ Date ; "<" & get(currentdate)-30 ]
    Perform Find []

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •