Convert timestamp to readable format | Community
Skip to main content
R
rupaul_20
January 6, 2023
Solved

Convert timestamp to readable format

  • January 6, 2023
  • 1 reply
  • 998 views

Hello all,

How I can display 2022-12-11T07:13:04Z timestamp to 11/12/2022 07:13:04 EST format. Could not find any useful helper function.

Tried following codes-

{%= stringToDate(context.journey.events.`eventId`.timestamp).getMonth() %} + "/" +
{%= stringToDate(context.journey.events.`eventId`.timestamp).getDayOfYear() %} + "EST" 

Output -

12 + "/" + 2022 + "EST" 

 

Tried following codes-

{% let var1 = split(context.journey.events.`eventId`.timestamp,"T") %}

{{var1}}

 

Output -

List(2022-12-11, 07:13:04Z)

 

Thank you for any help or guide.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by _Manoj_Kumar_

Hello @rupaul_20 

 

You can use this code

concat(format(context.journey.events.`eventId`.timestamp,"dd/MM/yyyy HH:mm:ss")," EST")

 

Working example:

 

1 reply

_Manoj_Kumar_
Community Advisor
_Manoj_Kumar_Community AdvisorAccepted solution
Community Advisor
January 9, 2023

Hello @rupaul_20 

 

You can use this code

concat(format(context.journey.events.`eventId`.timestamp,"dd/MM/yyyy HH:mm:ss")," EST")

 

Working example:

 

     Manoj     Find me on LinkedIn
    SatheeskannaK
    Community Advisor
    SatheeskannaKCommunity Advisor
    Community Advisor
    January 9, 2023

    @rupaul_20,

     

    One thing to either consider or make sure that the event id timestamp that you capture in AJO is in EST. Usually, the default timestamp will be on UTC.

     

    Thanks!

    Thanks, Sathees
      Terms & ConditionsAccessibility statement

      Loading footer...