A simplified version ... something like 1 Jan 2003 can be achieved by using
the expression below as your label expression.
Day(Date) + " " + Mid$("JanFebMarAprMayJunJulAugSepOctNovDec",
Month(Date)*3-2, 3) + " " + Year(Date)
For the full month, somewhat more manipulation would be required.
(month names are padded on the right with spaces to 9 characters. September
with 9 characters is the longest name .)
Day(Date) + " " + RTrim$(Mid$("January February March April May June July
August SeptemberOctober November December ", Month(Date)*9-8, 9)) + " " +
Year(Date)
There are length limitations in the expression window which might prohibit
the second solution.
I don't have any quick ideas on the 1st, 2nd, 3rd thing
Lorne
-----Original Message-----
From: Paul Mincher [mailto:[EMAIL PROTECTED]
Sent: July 8, 2005 12:41 PM
To: [email protected]
Subject: MI-L Data label formating in label expressions
Hi,
I'm trying to get Data label formatting in label expressions to convert, for
example, 01/01/2001 in the data table to format as
1st January 2001 rather than 20010101/
Any ideas
Paul Mincher
Data and Monitoring Officer
Greenwich Early Years Development and Childcare Partnership
Greenwich Council
151 Powis Street, Woolwich
London SE18 6JL
T 0208 921 3721
F 0208 921 3711
www.greenwich.gov.uk <http://www.greenwich.gov.uk/>
