omit from search records older than 6 months
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.
Hi Phil, thanks for that. I'm a bit of a novice so not too sure what im doing wrong. I've pasted that into a script in the specify calculation section and amended it with my table name and timestamp field --->
Enter Find Mode []
Set Field [Contact Management::Timestamp_Modified; "< " & Date ( Day (get (currentdate)); Month(get (currentdate))-6; Year(get(currentdate))]
Constrain Found Set
<---
when i click ok its highlighting "enter find mode" then telling me the specified table cannot be found, where do i specify the table?
thanks
armen.
Enter Find Mode []
Set Field [YourTable::YourTimeStampField; "< " & Date ( Day (get (currentdate)); Month(get (currentdate))-6; Year(get(currentdate))]
Constrain Found Set