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. ==================================-=============================
