mdy date in query -- MIDRANGE-L

Subject: mdy date in query
From: Angela Wawrzaszek <wawrzaszeka@xxxxxxxxxxx>
Date: Wed, 14 Mar 2001 12:31:38 -0500

Can I write a opnqryf to select records out of a file, where the date on the file is stored in MDY and I want to select dates out to process within a range. Since I can't sort the file by a logical - ie. 030100 through 030101 will not give me the correct records as will 000301 - 010301. How can I get the correct selection? I can not change the way the date is stored on this file since it is populated there by many different programs.

Angie Wawrzaszek
M.I.S. Department

Follow-Ups:

RE: mdy date in query , Mark Villa

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.