Forms 3, Y2K, DD-MON-YY in query mode.

[Quoted] Help, non-forms programmer needs help deparately.

I went through and inserted the ON-VALIDATE-FIELD trigger to convert entered dates to the DD-MON-RR Y2K compliant field (as per Oracle's Y2K document) and all works well for new records and updating existing records but I am unable to query dates properly. E.G. a date stored as actual date 1-jan-2001 cannot be queried. Querying for 1-jan-1 only retrieves records with actual date of 1-jan-1901.

I probably need to insert conversion code in a different trigger since I know for fact that my ON-VALIDATE-FIELD is not firing when in query mode.

No, I don't have a manual. No I am not a forms programmer. Yes, I am pathetic. No, I am not enjoying myself.

Thanks for any help that can be rendered..

[Quoted] nospam e-mail jmoran_at_baraboo.com Received on Tue Apr 07 1998 - 00:00:00 CEST