cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X

Translate the entire conversation x

Query builder filter

bwilson-2
8-Gravel
8-Gravel
‎Jun 27, 2011 12:19 PM
‎Jun 27, 2011 12:19 PM

Query builder filter

Hi all,


I have a QB query that creates a list change objects with their age. I would like to be able to show only the oldest 5. Basically only the five with oldest age. Anybody got any good ideas?


Thanks,


Brian

Labels:
0 Kudos
Notify Moderator
1 REPLY 1
MikeLockwood
22-Sapphire I
22-Sapphire I
(To:bwilson-2)
‎Jun 27, 2011 12:30 PM
‎Jun 27, 2011 12:30 PM

Not easily done in Windchill, but takes 2 seconds if you run the report from Excel via an Excel macro and apply calculations to the result in Excel.
0 Kudos
Notify Moderator
Announcements
Contact Community Management
Top Tags