Magic ETL

Magic ETL

Format Integer or Text String as Date

Member
edited December 2022 in Magic ETL

Hello,


I am using HubSpot Connector to create contact reports in Domo. A custom HubSpot Date property is pulling into Domo in a strange format and I can't seem to get this formatted as a date using Magic ETL or Beast Mode formulas that I have come across in other threads.

My first booked Calendly date field should in this screenshot should align with the Created Date.


Any input?

Tagged:

Best Answer

  • Coach
    Answer ✓

    Your Calendly date field is being store in millisecond unix timestamp. You can convert it to seconds by dividing by 1000 and then using FROM_UNIXTIME to convert it to an actual datetime type

    1. FROM_UNIXTIMESTAMP(`First Booked Calendly Date`/1000)
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • Coach
    Answer ✓

    Your Calendly date field is being store in millisecond unix timestamp. You can convert it to seconds by dividing by 1000 and then using FROM_UNIXTIME to convert it to an actual datetime type

    1. FROM_UNIXTIMESTAMP(`First Booked Calendly Date`/1000)
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Thank you, @GrantSmith ! This is exactly what I needed and worked perfectly. Thank you again for your assistance.


    Cheers!

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In