Re: Date funny in SQL*Forms 3.0

From: Peter A. Grant <grant_at_erich.triumf.ca>
Date: 18 Jan 1994 11:04 PST
Message-ID: <18JAN199411041706_at_erich.triumf.ca>


In article <2hhbfr$f38_at_nnrp.ucs.ubc.ca>, mirek_at_unixg.ubc.ca (Miroslaw Piaseczny) writes...
>...
>It could be a problem with usage of the mask format. Especially, make sure you
>don't specify 'MM' for the minutes part of the format.
>...

Thanks, Mirek. I actually figured it out this morning, and indeed it was using "MM" for the minutes portion of the time in the format mask. Pretty strange behaviour. It might have been more obvious if the time was displayed on the form, but it's not - it's hidden by default and just scrolled to.

A rather dumb "gotcha", but I don't use format masks very often.

Peter Grant           ////////  ///////  ////////  //    //  //    //  ////////
grant_at_triumf.ca         //     //    //     //    //    //  ///  ///  //
                       //     ///////      //    //    //  ////////  ///////
                      //     //  //       //    //    //  // // //  //
                     //     //    //  ////////  //////   //    //  //
                                               Canada's National Meson Facility
__________________________________________ _        Vancouver, British Columbia

             Communications Officer, Vancouver Oracle Users Group
Received on Tue Jan 18 1994 - 20:04:00 CET

Original text of this message