Thanks Marcus, I've set my Date format in Control Panel/Regional Settings to 17-Jan-2005 format.
However, even using FormatDate$(OPEN_DATE) my labels still look like this 01/03/1987 and not like this 01-Mar-1987 Any ideas? Zara Taylor Information Systems Analyst Customer Insight Unit * 181752 * 020 8718 1752 * [EMAIL PROTECTED] -----Original Message----- From: Markus Lindner [mailto:[EMAIL PROTECTED] Sent: 17 January 2005 14:26 To: Taylor, Zara Cc: [email protected] Subject: Re: MI-L Date Format in Labels Try the FormatDate$ Function, it prints the date according to your system environment, look at the windows control panel for your own local settings Regards Markus Taylor, Zara wrote: >Dear List, > >I have a mappable table of stores with an OPEN_DATE field. > >The OPEN_DATE field is in the format 01/03/1987 - I want to label my >stores with the date they opened, but I want the label to be in the >format March 1, 1987. > >How can I do this without having to making extra tables or extra >columns in my table? Is there a function that I can include in my >label expression? > >Many thanks > >Zara Taylor > > > > > >----------------------------------------------------------------------- > >================================================== >Registered Office: >Marks and Spencer plc >Waterside House >35 North Wharf Road >London >W2 1NW > >Registered No. 214436 in England and Wales. > >Telephone (020) 7935 4422 >Facsimile (020) 7487 2670 > ><<www.marksandspencer.com>> > >Please note that electronic mail may be monitored. > >This e-mail is confidential. If you received it by mistake, please let >us know and then delete it from your system; you should not copy, >disclose, or distribute its contents to anyone nor act in reliance on >this e-mail, as this is prohibited and may be unlawful. > > > -- CISS TDI GmbH <http://www.ciss.de/> Markus Lindner CISS TDI GmbH Tel. +49 2642 97 80 0 Barbarossastra�e 36 Fax. +49 2642 97 80 10 53489 Sinzig, Germany mailto:[EMAIL PROTECTED] http://www.ciss.de/ Sitz der Gesellschaft: Sinzig AG Andernach, HR-Nummer 3357 Gesch�ftsf�hrer: Dipl.-Math. Joachim Figura, Dipl.-Inform. Berthold B�rk ----------------------------------------------------------------------- ================================================== Registered Office: Marks and Spencer plc Waterside House 35 North Wharf Road London W2 1NW Registered No. 214436 in England and Wales. Telephone (020) 7935 4422 Facsimile (020) 7487 2670 <<www.marksandspencer.com>> Please note that electronic mail may be monitored. This e-mail is confidential. If you received it by mistake, please let us know and then delete it from your system; you should not copy, disclose, or distribute its contents to anyone nor act in reliance on this e-mail, as this is prohibited and may be unlawful.
