I’m using an API workflow to capture a Stripe event, however Stripe uses unix time for their date fields. Could the date field be updated to support unix time format? Otherwise is there a way for me to convert the unix time to the correct date format?

Am I setting this up wrong? How come I can’t access the date in step 2 after taking a string (unix timestamp) and converting it to a date in an api workflow? [image]

I have the exact same problem, and this looks like a perfect solution, however the links are broken and I can’t see what the solution is :frowning: Does anyone have a working link to these screenshots? (I assume they’re screenshots!) :pray:

@emmanuel any idea if this is being fixed in the near future? Is Stripe an outlier here in sending seconds vs. milliseconds or is this something that might have a fix in the future.

This is an action but I need to print data. Thoughts?

To be clear, what is the feature need, to be able to convert a timestamp in seconds into a date?

We shouldn’t have to use a plugin for this. On a Stripe object like Subscription, there are dozen of dates ! [image] API - Returned Value - Set DATE format Idea @Bubble , could you add “Date (UNIX)” as a type and convert it ? Right now we must use another plugin to handle…

[image] maryfox20: Is Stripe an outlier here in sending seconds vs. milliseconds or is this something that might have a fix in the future. Unix timestamp is in seconds. Javascript likes milliseconds. Annoying, but you can * or / by 1000 in most cases to get the number you need. Took me ages …

My use case is to turn the unix timestamp that Stripe sends back into a date. Right now, if I change the API call to recognize it as a date, it shows up with a 1970s date. If I change it to be a number, there’s no where for me to format the number as a date using the Unix timestamp logic. One fix w…

I’m also struggling integrating Intercom at the moment because of the need to send it UTC Unix formatted dates, it would be great if Bubble could handle this type of date format natively. All the plugins that did it seem to be broken.

[image] maryfox20: My use case is to turn the unix timestamp that Stripe sends back into a date. Perhaps I’m misunderstanding, but is there any reason one couldn’t simply initialize a date to 1/1/1970 and then “change seconds to”? For example, the following seems to work for me… [51%20PM] …

Convert unix time to date field

Need help Database

nicolas_dap October 1, 2019, 6:33am 13

We shouldn’t have to use a plugin for this.
On a Stripe object like Subscription, there are dozen of dates !

2 Likes

Topic		Replies	Views
Stripe API and UNIX Timestamps APIs	2	2312	July 7, 2023
Unix Timestamp to date with Bubble API Connector APIs	3	146	July 12, 2024
Timestamp convertion to Date(UNIX) Tips	21	14973	January 19, 2025
[bug resolved] Date (UNIX) is not converting stripe created time correctly Closed	2	90	January 21, 2025
Convert stripe unix timestamp to date Need help	2	2502	August 31, 2019

Convert unix time to date field

Related topics