Mike,
You always have to Year(), Month and Day() function to help you formatting the
date in just the way you want.
In your case this would do the trick:
Right$("00" + Month(DATE), 2) + "/" + Right$("00" + Day(DATE), 2) + "/" +
Year(DATE)
HTH,
Peter Horsbøll Møller
GIS Developer, MTM
Geographical Information & IT
COWI A/S
Odensevej 95
DK-5260 Odense S.
Denmark
Tel +45 6311 4900
Direct +45 6311 4908
Mob +45 5156 1045
Fax +45 6311 4949
E-mail [EMAIL PROTECTED]
http://www.cowi.dk/gis
COWI har fået ny hjemmeside. Ydelserne GIS og IT, kort, kortlægning, 3D
visualisering og arealforvaltning ligger under SAMFUND. Se mere her :
www.cowi.dk
COWI has changed its homepage. Our services within cadastre and
landadministration, geodataproducts, mapping and GIS can be seen under SOCIETY.
See our services here: www.cowi.com
-----Original Message-----
From: David Reid [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 7:23 PM
To: 'Cummings, Mike'; 'MapInfo-L (E-mail)'
Subject: RE: MI-L date fields in labels
I'm sure there's probably a better way to do it but this should work:
Change "DATE" to the name of your date column and assuming all dates are in the
same format and length:
Use the following expression to label with:
Mid$(DATE,5,2)+"/"+Right$(DATE,2)+"/"+Left$(DATE,4)
That should label in more user friendly results.
HTH
David Reid
GIS Manager
Colbert County 9-1-1
Colbert County, Alabama
This email and any attachments may contain confidential information. If you
have received it in error, notify the sender immediately and delete the email.
Thank you.
-----Original Message-----
From: Cummings, Mike [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 12:14 PM
To: MapInfo-L (E-mail)
Subject: MI-L date fields in labels
Is there an easy way to change the format of date fields in labels? (i.e.
change from 20040416 to 04/16/2004)
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17270
--
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.4/57 - Release Date: 07/22/2005
--
Outgoing mail is certified Virus Free
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.4/57 - Release Date: 07/22/2005
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com | To
unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17271
