Importing CSV File

[Fherrera]

Hi, this may a bit OT ..

But while trying to import a CSV file I get an error as the wizard cannot distinguish the date. Format looks like this:

TAG,DATE,VALUE
UNIT1_A5272019,6/29/1993 8:48 AM,3
UNIT1_A5272019,6/30/1993 12:00 AM,3

ie. MM/DD/YYYY HH:MM AM/PM

I tried the advanced tab during the wizard to get it to work, but it doesn't help.

Does anyone have other suggestions... Besides declaring it as a string that is?

Thanks

Frank

 

[TheCandyman]

that should work, as long as your date you are storing it into(DB) has the exact same formating. i would try just the date without the time, once you get that working, add the time, then AM/PM.