Follow

Why doesn't Surfer doesn't recognize my date/time data as date/times?

When a data file is created in another program with dates and times in it, Surfer will only recognize the data as dates and times if the data is either:

  1. In an Excel file (XLS, XLSX, XLSM) and the cells are actually formatted as dates and times (not as Text, General or Number).
  2. OR, if the data is in a text file format (like TXT, CSV, DAT), and the date / time data is in one of the standard U.S. Excel date and time formats, such as mm/dd/yy. If the format in the text file is not a U.S. Excel date/time standard format, the data will be imported into Surfer as text, and then you can’t use it as real data.

As long as the date/time data is formatted to fulfill one of the above requirements, you can use it to create grid files or create post maps. You can set the label format Type to Date/time and then select the desired Date format and Time format.

 

See also:

Working with Date/Time Data in Surfer

 

Surfer versions 11 and previous do not recognize dates and times as valid data. If you are using one of these versions, format the data as numeric data in Excel before using it in Surfer.

 

Updated October 23, 2017

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.