Products
  
  
  Crash Magic Online
  
  Intersection Magic
  
  Map Magic
  
  Knowledge Base
  
  
  
  Contact Us
  
  Meeting
  
  Shop
  
  Login
  

 

Knowledge Base Article:IMW21 


Registration keys moved to client area: Select login on the left menu bar.

Knowldegebase:
Search home page  

What date formats are accepted by Intersection Magic

Article created: Jul 09 1999, updated: Jul 09 1999

Background:  Dates may be represented may ways. Intersection Magic can handle most of them. This article describes which formats are supported and will be properly converted by the program.

Status:  Info - functionality description
Keywords:  date,format,century,y2k,mm/dd/yy
Categories:   *Importing* *Data*

Explanation:
The internal format for dates is Julian, which means that any other format sent to the program must be converted to Julian. The easiest and fastest format for conversion is mm/dd/ccyy. Any other format requires some massaging by the program. This massaging is done automatically. Below is a list of the formats which will be properly massaged to a correct date format automatically.

Solution:

Formats which will be converted properly during import or data entry

Those dates shown in bold are y2k compatible.
  • m/d/y
  • m/d/yy
  • m/d/ccyy
  • m/dd/yy
  • m/dd/ccyy
  • mm/d/yy
  • mm/d/ccyy
  • mm/dd/yy (standard)
  • mm/dd/ccyy (standard with century)
  • yy/mm/dd
  • mmm d yyyy
  • mmm d, yyyy
  • mmddyy
  • yymmdd
  • mmddccyy
  • ccyymmdd (standard dBase III IV)
  • mm/dd/ccyy hh:mm:ss (Microsoft Access time/date export format)

July 19, 2018 10:54PM

© 1999-2018 Pd' Programming, Inc - Lafayette, CO USA