Michel,
My suggestion is a workaround, because MSWIN doesn't have a function like today() available for use in the Explorer. It does provide Year(), Month(), DayofMonth().
I don't know if Explorer can handle integers this large, but I'd try:
10000*Year()+100*Month()+DayofMonth() in a single column, to give a sortable calendar date for the final day with data. You can then sort the column in descending order. The most recent hits will be at the top of the Explorer "hit" list. Ignore the ones you don't want.
If Metastock chokes on the single "Integer", you could use separate columns in the explorer for Year(), Month(), DayofMonth(), and sort on completion in 3 steps: Day-descending, Month-descending, Year-descending.
Paul |
