AnsweredAssumed Answered

How do I convert CSV dates yyyymmdd into date fields? GetAsDate calculation only returns ?

Question asked by mlcastellanos on Jul 5, 2018
Latest reply on Jul 5, 2018 by mlcastellanos

Hi,

I received a large table (.CSV) with student records and imported the table into a database. Each student has two date fields:  Field 1 ("Begin_Enrollment_Date") and  Field 2 ("End_Enrollment_Date").

 

When I look at the fields they both show as field type Text. I tried using Calc GetAsDate (Begin_Enrollment_Date), however I only get the value "?". I also checked to make sure the calculation value is returned as a date.

 

Any help would be appreciated.

 

M

Outcomes