I have imported some .txt files with the "Fixed Format File" node. The .txt files contain a field 'date of birth' with the characteristics "yyyymmdd" with no "/" of "-" between the year, month and day. I guess that is the reason why I cannot select type "date" for this field in the Field Positions.
What would be the easiest way to convert this string into a date? Data analyzer does not recognize the field as a date (it becomes "int"). The custom node "convert to date" does not recognize it either.
Please sign in to leave a comment.