Integration Management

Updated on August 2nd, 2024

+ More

Participate in our Help Center User Experience Survey to shape its future enhancements. It's quick, under 5 minutes, and your feedback is invaluable.

Order Sources

Custom Date Format - CSV Mapping

Overview

This article provides a guide on different date formats.

Extensiv Integration Management 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 Format

Date Format Spring	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 Sheets

Date	Description	Example
Week	---	---
Month	---	---
Year	---	---
Time	---	---
Timezone	---	---
Full Date / Time	---	---
z	The day of the year starting from 0	0 through 365
W	ISO-8601 week number of year, weeks starting on Monday	42 (the 42nd week in the year)
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 a given month	28 through 31
L	Whether it's a leap year	l if its 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 belongs to the previous or next year, that year is used instead	1999 or 2003
y	A two digit representation of a year	99 or 03
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 through 59
s	Seconds with leading zeros	00 through 59
u	Microseconds, will always be 000000 since timestamp data is only available to the second	654321
v	Milliseconds. Same notes applies as for u	654
e	Timezone identifier	UTC, GMT, Atlantic/Azores
I (capital i)	Whether or not the day is in daylight saving time	I if daylight, 0 otherwise
O	Difference to Greenwich time (GMT) in hours	+0200
P	Difference to Greenwich time (GMT) with colon between hours and minutes	+02:00
T	Timezone abbreviation	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
c	ISO 8601 date (added in PHP 5)	2004-02-12T15:19:21+00:00
r	Â» RFC 2822 formatted date	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

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.

cvs mapping date format