Convert date from Stripe (Unix Time Stamp) to MM/DD/YYYY for Salesforce
I am working on ingesting Stripe subscription data in to Salesforce and running into an issue on the date from the source (Stripe). Stripe appears to use a unix time stamp for the date an regardless of the expressions I use I am getting either 'null' values or 'invalid date' as a result. If anyone has done this transform before and point me to a solution I would be in your eternal debt.
0
Comments
Tim Krull you should be able to use this setting on the field level mapping to Salesforce.
Not sure how I missed that one, thanks for the quick reply
Silly how much time I worked on trying to build complex handlebars and didn't notice this field in the UI. Thanks for asking this! I finally got this working, and it was easy as choosing "x". oof.
Hi Everyone,
I'm trying to import a date in milliseconds using the standard mapping "Date Format" option, I got the following error:
Message: Unable to load timezone file: Celigo/Resources/Celigo.lib.timezone.OlsonTimeZoneData.js | Name: RCRD_DSNT_EXIST
Message: Ese registro no existe. path: Celigo/Resources/Celigo.lib.timezone.OlsonTimeZoneData.js
StackTrace:
at Celigo_SuiteApp.closure.js:1127
at Celigo_SuiteApp.closure.js:1116
at Celigo_SuiteApp.closure.js:1116
Any ideas?
Thanks
ARTURO DURAN MORENO can you send examples what what you have an what you need the output to be? Unix time is either in seconds or milliseconds. If in seconds, you need an uppercase "X", if in milliseconds, you need a lowercase "x".
Please sign in to leave a comment.