Sting field to dateformat.

Question

Hi there,

I have got a dataset with the with a "dateCreated" field.  However, the field is a sting field, and the format of the date is for eks 08.19  (month,year) in this case.

I would like to make this field into a datetime format, and have tried the formula:  DateTimeFormat(DateTimeParse([String],"%m.%y"),"%m/%Y"), but it does not work as it reports [null] in my new column.

Any suggestions ? 🙂

RolandSchubert · Accepted Answer

Hi @olehr ,

to turn the string field you have into a datetime field, you only need DateTimeParse([String], '%m.%y') and assign the Fieldtype "Date".

DateTimeFormat reconverts it to a string, so it will return NULL in a date field.

Does this help?

Regards

Roland