SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Metastock 6.0 for Window -- Ignore unavailable to you. Want to Upgrade?


To: MICHEL GUIBERT who wrote (2464)11/23/1998 9:24:00 PM
From: Paul Beattie  Read Replies (1) | Respond to of 4056
 
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