How to import csv file with a date variable of customized format?
Article ID: KB0074298
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 12.0 and higher |
Description
The article describes how to import a date variable with customized format (e.g. yyyymmdd) from a csv file.
Issue/Introduction
How to import csv file with a date variable of customized format?
Environment
Windows
Resolution
1.Click Statistica "Home | Open" menu, navigate to the csv data file and open it
2. Click the column with date information under "Text File" to highlight it in the preview pane
3. Change the "Data type" to be "Date" and select "Input format"
4. Click "Formatting" to specify the desired format and click "OK"
5. The value in the resulted spreadsheet should be formatted as a date in Statistica
Feedback
Yes
No
Powered by
