AnsweredAssumed Answered

Date Format Conversion Bug??

Question asked by DarrellFlenniken9941 on May 6, 2016
Latest reply on Dec 16, 2016 by DarrellFlenniken9941

Either I'm doing something wrong or I've found a rather nasty date format conversion bug.

This simple map demonstrates a problem I'm having with date format conversion.

 

Inbound Orders from SQL Server query.

 

 

 

The resulting CSV file:

 

"TRF","SSDate","yyyyMMdd HHmmss.SSS Date"

"T13-27681","2015-11-17 08:24:51.643","20151117 082451.643"

"AG2032F5","2015-12-14 02:43:27.317","20151214 024327.317"

"AG2033BA","2015-12-14 02:57:36.333","20151214 025736.333"

"AG203935","2015-12-23 07:47:51.69","20151223 074751.069"

"AG2036A3","2015-12-24 00:09:13.783","20151224 000913.783"

"AG2036A5","2015-12-24 00:11:35.85","20151224 001135.085"

"AG203363D","2015-12-29 08:39:41.263","20151229 083941.263"

"AG203347","2016-01-20 03:41:00.02","20160120 034100.002"

"AG203DBC","2016-04-11 09:33:45.77","20160411 093345.077"

"AG2023DD","2016-04-14 02:57:06.993","20160414 025706.993"

"AG202BFB","2016-04-18 05:20:34.753","20160418 052034.753"

"AG202BFB","2016-04-18 05:20:34.753","20160418 052034.753"

"AG202BFB","2016-04-18 05:23:54.827","20160418 052354.827"

"AG203C5C","2016-04-18 08:23:38.76","20160418 082338.076"

"AG203AF9","2016-04-20 00:22:33.047","20160420 002233.047"

"AG 203CA3","2016-04-21 07:34:36.987","20160421 073436.987"

"AG 203CA1","2016-04-21 07:37:43.993","20160421 073743.993"

"AG 203C97","2016-04-21 07:40:25.857","20160421 074025.857"

"AG2038A8","2016-04-26 06:42:49.403","20160426 064249.403"

"92050787","2016-04-27 07:51:52.147","20160427 075152.147"

"AG203433","2016-05-03 07:15:49.617","20160503 071549.617"

"AG203E2A","2016-05-03 08:28:11.0","20160503 082811.000"

"AG203F7C","2016-05-04 00:36:46.753","20160504 003646.753"

"AG201CED","2016-05-04 02:29:40.52","20160504 022940.052"

"AG203F7D","2016-05-04 03:40:12.093","20160504 034012.093"

"AG2025A6","2016-05-04 05:04:59.933","20160504 050459.933"

"AG203CB9","2016-05-04 05:38:34.857","20160504 053834.857"

"AG203F94","2016-05-04 05:46:27.313","20160504 054627.313"

"AG20362F","2016-05-04 08:03:28.833","20160504 080328.833"

"AG202BD5","2016-05-05 01:25:32.457","20160505 012532.457"

"AG203F86","2016-05-06 00:16:04.723","20160506 001604.723"

"AG203F8C","2016-05-06 00:20:58.113","20160506 002058.113"

"AG203F96","2016-05-06 01:05:14.667","20160506 010514.667"

"AG202A72","2016-05-06 01:55:13.507","20160506 015513.507"

"AG203AEA","2016-05-06 02:13:25.297","20160506 021325.297"

"AG203F8F","2016-05-06 02:23:25.657","20160506 022325.657"

"AG203AF2","2016-05-06 04:47:33.61","20160506 044733.061"

 

Can someone confirm this or slap me upside the head and set me straight.

Outcomes