On Thu, July 11, 2013 6:32 pm, Gene Wirchenko wrote: > At 10:29 2013-07-11, "MB Software Solutions, > LLC" <[email protected]> wrote: > > > [snip] > > >> Make sense now? Is there a better way? I did think of just leaving >> the date fields as C(8) and just rewriting the query logic (in a later >> UI) to search in MMDDYYYY fashion, but I liked the idea of >> dealing with actual dates (for now, anyway). >> >> How would you handle it? >> > > Create a new table for the data in the format I want, and > grovel through the unconverted table with a loop.
Hi Gene, That's what I've got in place now...a SCAN loop with conversion, or in an alternative version, I do a REPLACE RealDate with ConvertDate(TextDate) ALL in curTemp where ConvertDate is my UDF. I was just trying to squeeze better performance out of this. Thanks, --Mike _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
