>I want to set a bogus high date - so my app sets hold_start_dt = CTOD("01/31/9999"). But when start_dt gets sorted, first there are empty dates, then the 01/31/9999, and then the "real" dates. Why is that?
>
Hi Brenda,

How do you sort on hold_start_dt?