How do I get the correct date format for an import job?
I am trying to bring some data into Datameer, but it seems that my date is not being read properly. The date in my data looks like this pre-import:
20110102
During the import, it shows like this:
Aug 21,1970 11:38:21 PM
I am expecting it to show as Jan 2, 2011. How can I achieve this? Thanks!
-
Official comment
In order to get the correct date, you must put in the correct date parse pattern when you bring in the data. While setting up the data link, you will get a preview of your data, along with the column types. Under the DATE column header, you will see there is a place to put your date pattern.
If your date looks like 20110101 as you specified, you will want to enter YYYYmmdd. You can find more information on how to write date patterns here: https://documentation.datameer.com/documentation/display/DAS40/Date+and+Time+Parse+Patterns
Comment actions
Please sign in to leave a comment.
Comments
1 comment