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

---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 14879



Reply via email to