I have a simple ascii data file that I want to use:
1/4/2010 9:31,11.56,11.57,10
1/4/2010 9:32,11.46,11.56,11
1/4/2010 9:33,11.57,11.56,12
I get a "String '1/4/2010 9:31' was not recognized as a valid Data" error
What is the correct Date and Time format that I need to use?
I am using:
1/4/2010 9:31,11.56,11.57,10
1/4/2010 9:32,11.46,11.56,11
1/4/2010 9:33,11.57,11.56,12
I get a "String '1/4/2010 9:31' was not recognized as a valid Data" error
What is the correct Date and Time format that I need to use?
I am using:
Rename
1/4/2010 is not MM/dd/yyyy, the correct format string is M/d/yyyy
More info:
https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
More info:
https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
Your Response
Post
Edit Post
Login is required