Convert Date

[natalia_sjuntak]

I have an issue with converting date. I have tried many ways but the result is still null.

My date shows 01-Mar-2023 and had done converting string to date but was null.

I wanted the date shows 2023-03-01. Please anyone help to advise.

[ShankerV · Accepted solution]

Hi @natalia_sjuntak 

Please use Filter tool.

Filter tool settings:

Column name: Output

DateTimeParse([Field1],"%d-%b-%y")

Data type: Date

Many thanks

Shanker V

[ShankerV]

Hi @natalia_sjuntak 

One more method is using the Date time tool.

Date time tool settings:

Select the string field to convert: Input column

Specify your new column name: Desired output column name

Select the format that matches the incoming string field: Custom

dd-Mon-yyyy

Many thanks

Shanker V

[natalia_sjuntak]

Date time tool doesn't work in my case. I was frustrated using it many times, the outcome keeps showing "null". However, formula you told *DateTimeParse([Field1],"%d-%b-%y")* works for me.

[natalia_sjuntak]

Thank you @ShankerV