Integration Manager

Updated on December 6th, 2022

+ More

Order Sources

Custom Date Format - CVS Mapping

Extensiv Integration Manager users can configure date formats for outgoing CSV files, such as WMS - Order file, CSV Carts - Confirm file, and CSV Carts - Inventory files.

	CSV Carts	WMS Interface
Order File	Not Supported	Yes
Confirmation File	Yes	Not Supported
Inventory File	Yes	Not Supported

Date Format:

To edit date formats, please go to the Edit CSV File page. This function is only available on Edit CSV File page.

Commonly used date formats:

Date Format String	Results
(leave blank)	Integration Manager Default: 2001-03-10 17:16:18
Y-m-d H:i:s	2001-03-10 17:16:18
Y-m-d	2001-03-10
c	ISO 8601 Date: 2004-02-12T15:19:21+00:00
F j, Y, g:i a	March 10, 2001, 5:16 pm
m.d.y	03.10.01

Date Format Cheat Sheet:

*Date*	Description	Examples
d	Day of the month, 2 digits with leading zeros	01 to 31
D	A textual representation of a day, three letters	Mon through Sun
j	Day of the month without leading zeros	1 to 31
l (lowercase 'L')	A full textual representation of the day of the week	Sunday through Saturday
N	ISO-8601 numeric representation of the day of the week	1 (for Monday) through 7 (for Sunday)
S	English ordinal suffix for the day of the month, 2 characters	st, nd, rd or th. Works well with j
w	Numeric representation of the day of the week	0 (for Sunday) through 6 (for Saturday)
z	The day of the year (starting from 0)	0 through 365
*Week*	---	---
W	ISO-8601 week number of year, weeks starting on Monday	Example: 42 (the 42nd week in the year)
*Month*	---	---
F	A full textual representation of a month, such as January or March	January through December
m	Numeric representation of a month, with leading zeros	01 through 12
M	A short textual representation of a month, three letters	Jan through Dec
n	Numeric representation of a month, without leading zeros	1 through 12
t	Number of days in the given month	28 through 31
*Year*	---	---
L	Whether it's a leap year	1 if it is a leap year, 0 otherwise.
o	ISO-8601 week-numbering year. This has the same value as Y, except that if the ISO week number (W) belongs to the previous or next year, that year is used instead.	Examples: 1999 or 2003
Y	A full numeric representation of a year, 4 digits	Examples: 1999 or 2003
y	A two digit representation of a year	Examples: 99 or 03
*Time*	---	---
a	Lowercase Ante meridiem and Post meridiem	am or pm
A	Uppercase Ante meridiem and Post meridiem	AM or PM
B	Swatch Internet time	000 through 999
g	12-hour format of an hour without leading zeros	1 through 12
G	24-hour format of an hour without leading zeros	0 through 23
h	12-hour format of an hour with leading zeros	01 through 12
H	24-hour format of an hour with leading zeros	00 through 23
i	Minutes with leading zeros	00 to 59
s	Seconds, with leading zeros	00 through 59
u	Microseconds. Will always be 000000 since timestamp data is only available to the second.	Example: 654321
v	Milliseconds. Same note applies as for u.	Example: 654
*Timezone*	---	---
e	Timezone identifier	Examples: UTC, GMT, Atlantic/Azores
I (capital i)	Whether or not the date is in daylight saving time	1 if Daylight Saving Time, 0 otherwise.
O	Difference to Greenwich time (GMT) in hours	Example: +0200
P	Difference to Greenwich time (GMT) with colon between hours and minutes	Example: +02:00
T	Timezone abbreviation	Examples: EST, MDT ...
Z	Timezone offset in seconds. The offset for timezones west of UTC is always negative, and for those east of UTC is always positive.	-43200 through 50400
*Full Date/Time*	---	---
c	ISO 8601 date (added in PHP 5)	2004-02-12T15:19:21+00:00
r	Â» RFC 2822 formatted date	Example: Thu, 21 Dec 2000 16:01:07 +0200

Escape Characters

If you need to use a character in your date formatting that is a reserved character from above, it must be escaped. Escape characters by preceding them with a backslash: \

Example Format: \D\a\y Y-m-d

Example Result: Day 2017-01-30

CSV Date Format Sample:

The following example will put YYYY-MM-DD in the CSV order_date field.

^{This documentation page (and this page only) is licensed under Creative Commons Attribution 3.0. All other documentation is Copyright Extensiv.}

^{The "Data Format Cheat Sheet" portion of this page is originally from php.net}^{and has been modified to reflect the specific implementation used by Extensiv.}

Integration Manager

Custom Date Format - CVS Mapping

Date Format:

Commonly used date formats:

Date Format Cheat Sheet:

Date

Description

Examples

Week

---

---

Month

---

---

Year

---

---

Time

---

---

Timezone

---

---

Full Date/Time

---

---

Escape Characters

CSV Date Format Sample:

Related Articles

Not finding the help you need?