How to convert a text field to a date field

[Shaun Victor]

I currently have a text field where I am storing the date I first met someone. I have been entering it in this format in my text field: "4/23/2026" for someone I met on April 23. 

I want to convert this text field into a date field. Can you share with me how to do that? I think I need to use the CONVERT() function in SQL for this.

[Mmm]

Шаблон с примером в каталоге шаблонов:

https://mementodb.com/t/6110719823314944

четверг, 23 апреля 2026 г. в 19:54:48 UTC+3, sparkmy...@gmail.com:

[David Gilmore]

You can also do this using Javascript:

var e = entry();

var dt = new Date(e.field("textfield");
e.set("datefield", dt.getTime());

Check the Javascript documentation for the options and proper syntax.