Changing dates in old Forms?

[Quoted] When I took my current position, I inherited a number of forms that had been working, prior to the Y2K rollover. These forms seem to use a date of format "mm/dd/yyyy," and on the parameter form, you can enter the entire year in 4-digit format. However, when you run the report, it is trying to query for "20YY" instead of "YYYY" (i.e., 19YY). I've tried to change the Form to RRRR format, tried to change the query in the report, and have even tried to reverse-mask the date (i.e., "to_date (to_char (TODAY, 'MM/DD/YYYY'), 'MM/DD/YYYY')")--none of which are working.

Any insight you can give would be vastly appreciated.

Thanks in advance,

Julius Cooper

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 16 2000 - 00:00:00 CEST