Isn't it that the actual printed date format defined in the Windows "Regional settings"?
SET FORMAT DATE "LOCAL" "Users can configure various date ... formatting options by using control panels that are provided with the operating system" Jacques Paris e-mail [EMAIL PROTECTED] MapBasic-MapInfo support http://www.paris-pc-gis.com -----Original Message----- From: Woody Woodruff [mailto:[EMAIL PROTECTED] Sent: 6-Jan-04 15:30 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: MI-L formatdate usage Im not sure about your specific purpose in the workspace, not having read the tip you speak of, BUT I know how to get a long date, use it as you will: first create a table, Months.TAB with 2 columns, like this Create Table "Months" (Month_Integer Integer,Month_Name Char(10)) Populate this table with 1 January, 2 February, etc Run this query Select Month_Name+" "+Day(CurDate())+", "+Year(CurDate()) from Months where Month_Integer = (Month(CurDate())) into Todays_Long_Date This pulls the long month name from the table based on today's month (Month(CurDate()) in the WHERE clause, concatenate a space with " ", Day CurDate gives you the day of the month, concatenate a comma and space, then the year. If you are using the SQL wizard: Column Section, replace the * with- Month_Name+" "+Day(CurDate())+", "+Year(CurDate()) Table Section- Months.TAB Where section - Month_Integer = (Month(CurDate())) Into section - Todays_Long_Date The same expression maybe used as a label. Add Months (check editable) and Todays_Long_Date (check label) query into layer control and place a point object with N symbol (invisible), the long date appears, place that same point in a separate map window and place a frame in layout (use N for frame border), and the long date is in your layout window. William "Woody" Woodruff Zoning Administrator Charter Township of Union, Isabella County, Michigan -84.80947000 43.61095100 2010 S Lincoln Rd, Mt. Pleasant, MI 48858 (989) 772 4600 EXT 41 Visit our web site at http://www.geocities.com/ctuzoning/index.htm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 15:12 To: [EMAIL PROTECTED] Subject: MI-L formatdate usage I added the CurDate() to my default MapInfo workspace as shown in one of the knowledge base tips. Is there any way to make it a long date instead of the short date format? i.e. convert 01/06/04 to January 6, 2004. Thanks Kent Treichel Analyst-GIS Tax Research Minnesota Department of Revenue MS 2230 600 North Robert St St. Paul, MN 55146-2230 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9760 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9785 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9791
