Origin date format isn't recognized by Pyramid as a DATE
The system I use generates reports where the date is formatted as a string of numbers and I cannot figure out how to get model to see it as a date. I assume somewhere there is a solution where I can "explain" to model that the #'s are actually a date.... but how?
4 replies
-
The model cannot guess it's a date unless it's really a date. Add a calculated column that splits out the string using the "substring" functions and then reconstitute the elements as a proper date using the "createDate" function into a new column.
-
Hi
Or use the Convert block from Column Operations. Specify what type you want the column to be, Date, in this case, and how the string of numbers relates to year, month and day using the format string. Give a default value for anything that doesn't match and you're good to go. You can see in the preview the dates appearing correctly and the column is assigned the Date type in the properties panel.
Hope that helps.
Ian
-
Thanks. I knew it was somewhere but couldn't find it. I appreciate the help with these somewhat basic questions.
-
np. we're all here to learn
