Thank you, Albert & Razzak, this was the format that I thought I had read about somewhere. I did look through the documentation in all the places I could think of but I couldn't find this particular tid-bit - which is not to say it isn't there somewhere.
Naturally, it works perfectly with instant change of the "display" field on leaving the changed "edit" field. Regards, Alastair. ---------------------------------------------------------------------------- ------------ >Albert Berry wrote: >Have you thought about adding a calculated field along the lines of: >vShowDate TEXT = (FORMAT(DateField,'WWW+, MMM+ DD, YYYY')) >adjacent to the input field? It should update immediately. ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, October 27, 2001 1:11 PM Subject: Re: Date displays on forms - Razzak's Reply > > At 07:33 PM 10/26/01 +0100, Alastair Burr wrote: > > >I am trying to go into a simple column date field to edit > >'01/01/2001' it and immediately display its expanded result > >version as 'Monday 1st January 2001' (or whatever it is). > > > Alastair, > > This is due to the database default SETting of DATE FORMAT > and DATE SEQUENCE, i.e: > > Your database default DATE SETtings are probably like: > > DATE FORMAT 'WWW+ DD MMM+ YYYY' > DATE SEQUENCE DDMMYYYY > > So, if you don't want to display the date format like above, > you can simply SET the DATE FORMAT to DD/MM/YYYY and DATE > SEQUENCE to DDMMYY. (of course you need to set DATE YEAR > and DATE CENTURY thresholds accordingly). > > That should take care of the situation as described above. > > So, let the user(s) enter/edit date fields in forms as > normally displayed DATE FORMAT and SEQUENCE. > > Now, if you need to DISPLAY the date results as expanded > date format in Forms, Reports or Labels, then, I would > recommend to use the FORMAT FUNCTION option in Forms, > Reports and Labels. > > In Forms, you'll need to create a dummy TEXT variable using > FORMAT FUNCTION to display expanded date without changing > the actual DATE FORMAT, such as: > > vDisplay = (FORMAT(DateColumn,'WWW+ DD MMM+ YYYY')) > > That would display the DateColumn with 27/10/2001 like: > > Sunday 27 October 2001 > > In Reports and Labels, you can take advantage of the field > 'Picture Format...' option to display date format without > creating a dummy TEXT variable. > > Enjoy and make sure to have fun! > > Very Best Regards, > > Razzak. > > > ===================================-============================ > Official R:BASE List Server: mailto:[EMAIL PROTECTED] > RBTI Events/Training: http://www.rbase2000.com/events > R:DCC Members: http://www.rbase2000.com/rdcc > ================================================================ > R:BASE, Oterro & R:Tango are registered trademarks of RBTI. > ==================================-============================= >
