Title
omit from search records older than 6 months
Post
hi, i'd like to include a button on my form that after a search has been run, it will omit all records that have been timestamped as not modified for over 6 months. How do i do this calculation?
Thanks
Armen.
Enter Find Mode []
Set Field [YourTable::YourTimeStampField; "< " & Date ( Day (get (currentdate)); Month(get (currentdate))-6; Year(get(currentdate))]
Constrain Found Set