Convert text date to UNIX timestamp

[Javier_Vinas]

Hi Makers!

I’m reaching out for help with one “easy” task - I need to convert this text string: 22/11/2022

to a UNIX timestamp date format in milliseconds. Here’s my attempt, but I think I’m missing something because the output is empty.

Appreciate some help

[alex.newpath]

You need to first parse and then format the date. The nesting should be inverted in your screenshot.

Also the parsedate() input mask is

DD/MM/YYYY

[Javier_Vinas]

Hey Alex! Apologies for the delay in getting back to this.

I tried the approach you mentioned and it worked. At the end I didn’t need to use the parsedate() function, it was an issue understanding the input mask that I should be using.

Thanks a lot for your help