Entering Dates in the CSV Templates

In handling imports of CSV files, FlexNet Business Importer uses the default .NET data parsing algorithm. This uses the current culture setting (Regional Settings) for the account running the Business Importer on the application server doing the import to determine acceptable date/time formats.

This means that you can enter dates in CSV templates using the normal format in which dates are entered in the IT Asset Management web interface.

If in doubt, use what .NET calls the UniversalSortableDateTimePattern:
YYYY-MM-DD
YYYY-MM-DD HH:mm:ssZ
Examples:
2016-03-28
2017-09-21 11:14:00Z
2018-11-03 23:00:00Z
For information only, other formats in U.S. English that are acceptable for .NET and usable for data entry in IT Asset Management include:
Name Format / Example
FullDateTimePattern
dddd, MMMM dd, yyyy h:mm:ss tt
Example: Monday, May 28, 2017 11:35:00 AM
LongDatePattern
dddd, MMMM dd, yyyy h:mm:ss tt
Example: Monday, May 28, 2017 11:35:00 AM
RFC1123Pattern
ddd, dd MMM yyyy HH:mm:ss GMT
Example: Mon, 28 May 2016 11:35:00 GMT
ShortDatePattern
M/d/yyyy
Example: 5/28/2017
SortableDateTimePattern
yyyy-MM-ddTHH:mm:ss
Example: 2017-05-28T18:35:00

IT Asset Management (Cloud)

Current