Convert text date to UNIX timestamp

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.

Screenshot 2022-11-21 at 11.09.37

Appreciate some help :slight_smile:

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

1 Like

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

3 Likes