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.
