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
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