Re: system.cursor_value century problem

In article <336119C7.31A1_at_umabnet.ab.umd.edu>, Mark Waring <mwaring_at_umabnet.ab.umd.edu> wrote:
>In Forms4.5, :SYSTEM.CURSOR_VALUE returns DD-MON-YY for a text item with
>the datatype of DATE even if the format property is MM/DD/YYYY.
>
>In SQL*Forms V3.0, :SYSTEM.CURSOR_VALUE returns DD-MON-YYYY for a Date
>field if the format is MM/DD/YYYY.
>
>Is there a GENERIC way around this problem in Forms4.5?
>
>I'd appreciate any suggestions. You can email me at
>mwaring_at_umabnet.ab.umd.com
>
>Thanks for your help,
>
>Mark Waring

The following works if you have a matching format-mask on the date item on the form. If the item on the form only has YY in the mask, this does not work:

   d:=to_date(:system.cursor_value,'DD-MON-YYYY');

(where d is declared as a date variable).

Also, I believe that this did not work before Forms 4.5.5.5 (d2k, v1.2)

HTH
Steve Cosner Received on Mon Apr 28 1997 - 00:00:00 CEST