C# 2010 How to Query DateTime Range for DBF 2 Digit Dates RRS feed

  • Question

  • Ok, not 2 digits, but it's 2 each, mmddyy.   I'm trying to get a script that could pull everything from say 01/01/01 to 01/25/01, and only get those dates.   I've tried quite a few methods that have all been epic fails.  Tried substringing the dates, converting them to integers and querying on increments of the days.  Tried a counter class to record the days, months, etc, and iterate like that.  Fail.

    Where invdte = ?

    I'm pretty sure I've found threads on a BETWEEN function or something similar, but those all relied on 4 digit year, which I don't have.   Anyone got a good approach for this?

    May the fleas of a thousand camels feast happily on the lower regions of your enemies. And may their arms be too short to scratch!
    Friday, January 27, 2012 6:40 PM


All replies