1 of 1 people found this helpful
get ( foundcount ) > 40
go to record 41
omit multiple records [ get ( foundcount ) - 40 ]
go to record 1
After the sort,
Go to Record/Request/Page [No dialog; 41]
Omit Multiple Records [No dialog; 1000000000000]
Go to Record/Request/Page [First]
That generally works, too, but... if there are less than 41 records (and you ignore the error) you'll still perform the omit step. Also, the omit step will throw an error if there are less records (though you could ignore it) or not omit enough if there are more than 100040 records.
There will always be more than 40 records. I just want to constrain the results to the most recent 40. I will test out the script you suggested. Thanks!