9999 in date range generates error

[SJG0526]

We're using Crystal Reports 8.5. In VB6 we have:

CRPrt.SelectionFormula = "{Dtl.MDate} in Date (" & DatePart("yyyy", BegDate) & "," & DatePart("m", BegDate) & "," & DatePart("d", BegDate) & ") to Date (" & DatePart("yyyy", EndDate) & "," & DatePart("m", EndDate) & "," & DatePart("d", EndDate) & ")"

Getting a dll error when the enddate = 12/13/9999. It works if the enddate is 12/31/3999. Has anyone run into this problem and if so, do you know why and what the max date would be to make it work?

Thanks

 

[Madawc]

Crystal won't store 12/13/3999 as such, but translate it into an internal formal. I'd suppose that 12/13/9999 is beyond the allowable ranges.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10