Parsing text to date format

[Duc Thang TRAN]

Hello Every one , 

I'm looking for a solution to convert a text field into a date-time format.

For example, I have a Text 3 field with a value like: 12/02/2025 13:51:21.

I need a smart value that can save this value into a date-time field. The default format on my instance is dd/MMM/yyyy h:mm a.

I'm using .toDate, but it’s not working until I change my text field value to 12/Feb/2025. Do you know a way to convert a text field when its format differs from the instance's default date format?

[Vishal Biyani · Accepted solution]

@Duc Thang TRAN 

with toDate you need to specify the format. Are you doing that?

Once string is converted to date, use .format to update the date format

.toDate("yyyy-MM-dd").format("MM/dd/yyyy H:m:s ")

[Duc Thang TRAN]

@Vishal Biyani 

Finnaly i'm able to using this smart value and save to date time field 

.ToDate("dd/MM/yyyy HH:mm:ss")

[Vishal Biyani]

Good to know that this worked for you