>Hi everybody,
>
>In our old Legacy tables we store date in a Character format. I'm trying this test in VFP (it doesn't work in FP also):
>
>lcDate=dtoc(date()-10)
>?between(lcDate,"12/01/2000","01/29/2001")
>
>How can I make it work in FPD 2.6, where strict date format was not introduced, I suppose?
>
>Thanks in advance
Well, seems like the only way to use:
between(ctod(date),date1, date2) This would slow queries a little bit...
But the result would be correct, which is the only that matters!
If it's not broken, fix it until it is.
My Blog