Convert date from Stripe (Unix Time Stamp) to MM/DD/YYYY for Salesforce

Tim Krull
Engaged
Celigo University Level 1: Skilled

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

3 comments

Date Votes
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    Tim Krull you should be able to use this setting on the field level mapping to Salesforce.

    0
  • Tim Krull
    Engaged
    Celigo University Level 1: Skilled

    Not sure how I missed that one, thanks for the quick reply

    1
  • DJ Monzyk

    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.

    1

Please sign in to leave a comment.

Didn't find what you were looking for?

New post