Table of Contents

What date formats are accepted by Intersection Magic

Issue

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.

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)

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?