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
