<sourceTimestamp>{formatDate(optout.@OPT_Date, "%4Y-%2M-%2DT%02H:%02N:%02S") + "+00:00"}</sourceTimestamp> | Community
Skip to main content
S
Shrutii
Level 4
May 4, 2023
Solved

<sourceTimestamp>{formatDate(optout.@OPT_Date, "%4Y-%2M-%2DT%02H:%02N:%02S") + "+00:00"}</sourceTimestamp>

  • May 4, 2023
  • 2 replies
  • 671 views

  • What is meanin of this: <sourceTimestamp>{formatDate(optout.@OPT_Date, "%4Y-%2M-%2DT%02H:%02N:%02S") + "+00:00"}</sourceTimestamp>

     

    OPT_Date - data type of this field "OPT_Date"  is defined ad "date" in  adobe db

    what this will do to any date :

     

    formatDate(optout.@OPT_Date, "%4Y-%2M-%2DT%02H:%02N:%02S") + "+00:00"

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 david--garcia

Formats the date value contained in optout.@OPT_Date  with the given format

https://experienceleague.adobe.com/developer/campaign-api/api/f-formatDate.html

 

You can specify a number in front of certain of these characters. The A and B characters can be followed by a l to use the full name rather than the shortened version or a i to use the name in English. Examples:

  • "%4Y/%2M/%2D" => 2000/01/24.
  • "%A %D %B %4Y" => mon 24 jan 2000.
  • "%Al %D %Bl %4Y" => monday 24 january 2000.
  • "%02H:%02N:%02S" displays the hour, minutes and seconds to two figures.

2 replies

david--garcia
david--garciaAccepted solution
Level 10
May 4, 2023

Formats the date value contained in optout.@OPT_Date  with the given format

https://experienceleague.adobe.com/developer/campaign-api/api/f-formatDate.html

 

You can specify a number in front of certain of these characters. The A and B characters can be followed by a l to use the full name rather than the shortened version or a i to use the name in English. Examples:

  • "%4Y/%2M/%2D" => 2000/01/24.
  • "%A %D %B %4Y" => mon 24 jan 2000.
  • "%Al %D %Bl %4Y" => monday 24 january 2000.
  • "%02H:%02N:%02S" displays the hour, minutes and seconds to two figures.
    LakshmiPravallika
    Community Advisor
    LakshmiPravallikaCommunity Advisor
    Community Advisor
    May 5, 2023

    Hi @shrutii ,

     

    The Function formatDate(optout.@OPT_Date, "%4Y-%2M-%2DT%02H:%02N:%02S") + "+00:00", will given the Output in a Workflow  when a variable is set to that above Value then the Output will be "YYYY-MM-DDTHH:MM:SS+00:00"

     

    Example Data for todays Date and Time:

    2023-05-22T16:22:15+00:00

     

    Regards,

    Pravallika.

      Terms & ConditionsAccessibility statement

      Loading footer...