AnsweredAssumed Answered

PI UFL Interface - Invalid time format

Question asked by ArchNandakumar on Jun 12, 2019
Latest reply on Jun 13, 2019 by ArchNandakumar

I am trying to read from a csv file which has a timestamp input 10/12/2018 12:00:00 AM and I have configured my .ini file to read 

Name: Last update

DataType: DateTime

DateFormat: "M/dd/yyyy h:m:s pp"

 

I get this error for several lines from the csv

PI_UFL:PI_UFL:UFL | 3 | 0 (2)
>> Error: Invalid time format: 10/12/2018 12:00:00 AM.

PI_UFL:UFL | 3 | 0 (2)
>> Error: Invalid time format: 6/7/2019 12:00:00 AM.

 

Lal Babu Shaik Dan Fishman Gregor Beck

Pls help! I have changed the time format to M/dd/yyyy h:m:s and still getting the same error. 

Same csv file has another timestamp in the same line which as been configured the same as abv and it does not throw any errors.

Outcomes