04-13-2015 09:53 AM
I've imported an excel file into VA,
I've got a field which is a timestamp (dd/mm/yyyy:hh:mm) , but it is taken as character by VA.
if I create a calculated item , how can I convert it from char to date?...
any idea about the instruction?
thanks a lot!
04-13-2015 10:00 AM
You might be encountering the issue in 52060 - SAS® Visual Analytics might import date values in a Microsoft Excel spreadsheet as character.... Can you confirm that the value in Excel is truly stored as time?
04-13-2015 10:08 AM
I believe that the Parse() operator should do what you need.
Parse() is categorized as a "Text (simple)" operator. Select the ANYDTDTE format to return a date value, or ANYDTDTM to return a date-time value.
Hope that helps!
04-13-2015 10:13 AM
Could it be that you're experiencing a similar issue as before? https://communities.sas.com/thread/64936
Please check your Excel file for any characters in the column. If there are missing dates, how are they represented?