Re: Changing dates in old Forms?

From: Jerry Alan Braga <jabraga_at_golden.net>
Date: 2000/05/16
Message-ID: <8fs5sl$74j$1_at_cougar.golden.net>#1/1


have you checked what the NLS_DATE_FORMAT env variable is set to.

it should be set to DD-MON-YYYY to be fully compliant.

<julius_cooper_at_my-deja.com> wrote in message news:8frsi8$ett$1_at_nnrp1.deja.com...
> 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

Original text of this message