Capturing Date Format and converting it to seconds

How can I fix the following error?

I am trying to convert the date format to milliseconds.
The data was initially 10/20/2024 12:00:00 AM
I split the information there after and was left with 10/20/2024
When I try to convert it from yyyy/MM/dd to unix_seconds

This conversion doesn’t happen.
I tried changing formats to yyyy-MM-dd by splitting the data and merging it with ‘-’ I was still unable to change the formatting.

The main reason to make this conversion is to add 30 days to the date.
Is there any other way to do this or fix this error.

I have included an attachment for your reference.

Hello @IT :wave:

Thanks for flagging. To convert a date format into unix_seconds, the initial date format requires a timestamp. It looks like the initial date format, included a midnight timestamp, so try using the Format dates before splitting and merging the data.

You can also prompt the AI to convert the “NewDate” column in your current setup into unix_seconds by specifying your converted timestamp should start at midnight.

Let me know if this works!

Thank you Daniel. Your feedback was quite helpful.
I continued splitting the date but merging the day and time with a different delimiter.
I was able to capture the right format after that