# Capturing Date Format and converting it to seconds

**URL:** <https://community.parabola.io/t/capturing-date-format-and-converting-it-to-seconds/3051>\
**Category:** Ask a question\
**Tags:** Building-Flows\
**Created:** [October 30, 2024, 3:34am UTC](https://community.parabola.io/t/capturing-date-format-and-converting-it-to-seconds/3051 "2024-10-30T03:34:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![IT](https://avatars.discourse-cdn.com/v4/letter/i/df705f/32.png) [@IT](https://community.parabola.io/u/IT)\
**Post date:** [October 30, 2024, 3:34am UTC](https://community.parabola.io/t/capturing-date-format-and-converting-it-to-seconds/3051/1 "2024-10-30T03:34:15Z")

</div>

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.

 ![Parabola Error](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/b/b90897b3b79e114a9d3b9e28dcd6d717cfcc5097.png)

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [October 30, 2024, 5:32pm UTC](https://community.parabola.io/t/capturing-date-format-and-converting-it-to-seconds/3051/2 "2024-10-30T17:32:46Z")

</div>

Hello @IT 👋

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!

---

<div class="post-metadata">

**Author:** ![IT](https://avatars.discourse-cdn.com/v4/letter/i/df705f/32.png) [@IT](https://community.parabola.io/u/IT)\
**Post date:** [October 31, 2024, 5:31am UTC](https://community.parabola.io/t/capturing-date-format-and-converting-it-to-seconds/3051/3 "2024-10-31T05:31:45Z")

</div>

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