Paul
Here is a very messy solution. Hopefully, someone else can provide
something better.
There is a limitation of something like 255 characters in the Label
Expression box. If your date field name is kept short (Dt below), then the
following string will get close to the date formatting you want (8th July
2004). Still missing the superscript.
Day(Dt)+Mid$("stndrdthththththththththththththththththstndrdthththththththst
",Day(Dt)*2-1,2)+" "+ RTrim$(Mid$("January February March April May
June July August SeptemberOctober November December
",Month(Dt)*9-8,9))+" "+Year(Dt)
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
