Multiple field format Changes String to date

[Vyx]

Hi All,

I have multiple date fields that are currently appearing as string fields - I can't use the select tool to convert the fields into date format unfortunately so wanted to ask if anyone knows of a way to change multiple fields into date format without having to add multiple date time tools to change the format from string to date? 

Appreciate all your help in advance! 

Kind Regards,

Vyx

[binu_acs]

@Vyx use the DateTimeParse function to change string to date 

Spoiler

[AngelosPachis]

Ho @Vyx ,

The fastest way is to use a multi-field formula, assuming all date fields are written in the same format (i.e. all are year/month/date)

In the below example, my date fields are given in this format

With the multi-field formula tool, I can select which string fields I want to configure, change the output type to date and use an expression that will apply to all 3

Hope that helps,

Angelos