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