EDI date converter
Paste a date from an X12 or EDIFACT file and read it in plain English, or pick a date and get it in every EDI format.
- X12 and EDIFACT formats
- Julian dates
- DTM qualifier lookup
Lookup
Date qualifiers and format codes
What the code in front of a date means: X12 DTM01 qualifiers and DTM05 formats, EDIFACT DTM qualifiers (2005) and format codes (2379).
72 of 72 codes
| Code | Meaning | Where |
|---|---|---|
| 001X12 | Cancel afterDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 002X12 | Delivery requestedDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 003X12 | InvoiceDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 004X12 | Purchase orderDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 007X12 | EffectiveDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 010X12 | Requested shipDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 011X12 | ShippedDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 015X12 | Promotion startDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 017X12 | Estimated deliveryDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 018X12 | AvailableDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 035X12 | DeliveredDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 036X12 | ExpirationDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 037X12 | Ship not beforeDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 038X12 | Ship no laterDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 050X12 | ReceivedDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 063X12 | Do not deliver afterDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 064X12 | Do not deliver beforeDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 067X12 | Current schedule deliveryDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 068X12 | Current schedule shipDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 069X12 | Promised for deliveryDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 079X12 | Promised for shipmentDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 097X12 | Transaction creationDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 106X12 | Required byDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 118X12 | Requested pick-upDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 168X12 | ReleaseDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 196X12 | StartDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| 197X12 | EndDTM01 date/time qualifier (374) | DTM01 date/time qualifier (374) |
| CMX12 | CCYYMMDTM05 format qualifier (1250) | DTM05 format qualifier (1250) |
| CYX12 | CCYYDTM05 format qualifier (1250) | DTM05 format qualifier (1250) |
| D6X12 | YYMMDDDTM05 format qualifier (1250) | DTM05 format qualifier (1250) |
| D8X12 | CCYYMMDDDTM05 format qualifier (1250) | DTM05 format qualifier (1250) |
| DTX12 | CCYYMMDDHHMMDTM05 format qualifier (1250) | DTM05 format qualifier (1250) |
| DTSX12 | CCYYMMDDHHMMSS-CCYYMMDDHHMMSSDTM05 format qualifier (1250) | DTM05 format qualifier (1250) |
| RD8X12 | CCYYMMDD-CCYYMMDDDTM05 format qualifier (1250) | DTM05 format qualifier (1250) |
| RDTX12 | CCYYMMDDHHMM-CCYYMMDDHHMMDTM05 format qualifier (1250) | DTM05 format qualifier (1250) |
| TMX12 | HHMMDTM05 format qualifier (1250) | DTM05 format qualifier (1250) |
| 2EDIFACT | Delivery requestedDTM qualifier (2005) | DTM qualifier (2005) |
| 3EDIFACT | Invoice dateDTM qualifier (2005) | DTM qualifier (2005) |
| 4EDIFACT | Order dateDTM qualifier (2005) | DTM qualifier (2005) |
| 10EDIFACT | Shipment requestedDTM qualifier (2005) | DTM qualifier (2005) |
| 11EDIFACT | Despatch dateDTM qualifier (2005) | DTM qualifier (2005) |
| 13EDIFACT | Terms net due dateDTM qualifier (2005) | DTM qualifier (2005) |
| 17EDIFACT | Delivery estimatedDTM qualifier (2005) | DTM qualifier (2005) |
| 35EDIFACT | Delivery actualDTM qualifier (2005) | DTM qualifier (2005) |
| 36EDIFACT | Expiry dateDTM qualifier (2005) | DTM qualifier (2005) |
| 50EDIFACT | Goods receipt dateDTM qualifier (2005) | DTM qualifier (2005) |
| 63EDIFACT | Delivery latestDTM qualifier (2005) | DTM qualifier (2005) |
| 64EDIFACT | Delivery earliestDTM qualifier (2005) | DTM qualifier (2005) |
| 76EDIFACT | Delivery scheduledDTM qualifier (2005) | DTM qualifier (2005) |
| 94EDIFACT | Production dateDTM qualifier (2005) | DTM qualifier (2005) |
| 97EDIFACT | Transaction creation dateDTM qualifier (2005) | DTM qualifier (2005) |
| 132EDIFACT | Arrival estimatedDTM qualifier (2005) | DTM qualifier (2005) |
| 133EDIFACT | Departure estimatedDTM qualifier (2005) | DTM qualifier (2005) |
| 137EDIFACT | Document dateDTM qualifier (2005) | DTM qualifier (2005) |
| 140EDIFACT | Payment due dateDTM qualifier (2005) | DTM qualifier (2005) |
| 157EDIFACT | Validity start dateDTM qualifier (2005) | DTM qualifier (2005) |
| 158EDIFACT | Horizon start dateDTM qualifier (2005) | DTM qualifier (2005) |
| 159EDIFACT | Horizon end dateDTM qualifier (2005) | DTM qualifier (2005) |
| 171EDIFACT | Reference dateDTM qualifier (2005) | DTM qualifier (2005) |
| 194EDIFACT | Start date/timeDTM qualifier (2005) | DTM qualifier (2005) |
| 206EDIFACT | End date/timeDTM qualifier (2005) | DTM qualifier (2005) |
| 361EDIFACT | Best before dateDTM qualifier (2005) | DTM qualifier (2005) |
| 101EDIFACT | YYMMDDDTM format code (2379) | DTM format code (2379) |
| 102EDIFACT | CCYYMMDDDTM format code (2379) | DTM format code (2379) |
| 105EDIFACT | YYDDDDTM format code (2379) | DTM format code (2379) |
| 201EDIFACT | YYMMDDHHMMDTM format code (2379) | DTM format code (2379) |
| 203EDIFACT | CCYYMMDDHHMMDTM format code (2379) | DTM format code (2379) |
| 204EDIFACT | CCYYMMDDHHMMSSDTM format code (2379) | DTM format code (2379) |
| 401EDIFACT | HHMMDTM format code (2379) | DTM format code (2379) |
| 402EDIFACT | HHMMSSDTM format code (2379) | DTM format code (2379) |
| 718EDIFACT | CCYYMMDD-CCYYMMDDDTM format code (2379) | DTM format code (2379) |
| 719EDIFACT | CCYYMMDDHHMM-CCYYMMDDHHMMDTM format code (2379) | DTM format code (2379) |
Reference
EDI date and time formats
| Format | Example | In X12 | In EDIFACT |
|---|---|---|---|
| CCYYMMDD (EDIFACT 102) | 20261027 | DTM02, BEG05, BIG01, GS04 and most X12 dates (DTM05 D8) | DTM C507, format code 102 |
| YYMMDD (EDIFACT 101) | 261027 | ISA09, the interchange date (DTM05 D6) | DTM C507, format code 101 |
| CCYYMMDDHHMM (EDIFACT 203) | 202610271432 | DTM05 DT | DTM C507, format code 203 |
| CCYYMMDDHHMMSS (EDIFACT 204) | 20261027143005 | — | DTM C507, format code 204 |
| CCYYMMDD-CCYYMMDD (EDIFACT 718) | 20261101-20261130 | DTM05 RD8 | DTM C507, format code 718 |
| YYDDD Julian (EDIFACT 105) | 26300 | — | DTM C507, format code 105 |
| CCYYDDD Julian | 2026300 | — | — |
| HHMM (EDIFACT 401) | 1432 | ISA10, GS05, DTM03 (DTM05 TM) | DTM C507, format code 401 |
| HHMMSS (EDIFACT 402) | 143005 | GS05, DTM03 | DTM C507, format code 402 |
CCYY is the four-digit year, DDD the day of the year. X12 times may also carry decimal seconds (HHMMSSD); the converter reads whole seconds.
FAQ
EDI date questions
How does EDI write dates?
As digits with no separators. Since version 4010, X12 dates are CCYYMMDD (20261027) and times HHMM or HHMMSS; the ISA interchange header still uses a two-digit year, YYMMDD. EDIFACT puts the format in the DTM segment itself: DTM+137:20261027:102 means document date, 27 October 2026, in format 102 (CCYYMMDD).
Which century does a two-digit year mean?
X12 does not say. This converter reads 00 to 49 as 2000 to 2049 and 50 to 99 as 1950 to 1999, the usual fixed window. For an ISA09 interchange date that is always right, because the date is the day the file was sent.
What is a Julian date in EDI?
The day of the year, counted from 1 January as day 001: YYDDD (EDIFACT format 105) or CCYYDDD. 26300 is day 300 of 2026, 27 October. Lot and batch codes and some legacy systems use it; in a leap year 31 December is day 366.
What is the difference between a date qualifier and a date format?
The qualifier says what the date is for: in X12 DTM01, 002 is delivery requested and 011 is shipped; in EDIFACT, 2 is delivery requested and 137 the document date. The format says how it is written, such as EDIFACT 102 (CCYYMMDD) or X12 DTM05 RD8 for a range.
Are the dates converted to my time zone?
No. An EDI date is a calendar date as the sender wrote it, so the converter keeps it exactly as it is. X12 can add a time code in DTM04 when a time zone matters.
Dates your ERP and your partners agree on
Comparatio maps every date and qualifier between your partners’ files and Prophet 21, NetSuite or CloudSuite Distribution.