Session.Write: Insert date | Community
Skip to main content
T
timg96297954
Level 2
October 2, 2017
Solved

Session.Write: Insert date

  • October 2, 2017
  • 2 replies
  • 4263 views

Hi guys,

I would like to use JavaScript to update a record in the recipient table.

I use the session.Write-function. How can I insert the current time into the date field "lastUpdate" in the schema for recipient "12345"?

xtk.session.Write(<recipient _operation="update" _key="@id" lastUpdate={getDate()} id="12345" xtkschema="nms:recipient"/>);

getDate does not work.

Thanks for your help in advance.

Greetings,

Tim

    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 sambhavj5011451

    Hi Tim,

    This works well.

    var modifiedDate = formatDate(new Date(), "%4Y-%2M-%2D %02H:%02N:%02S")

    xtk.session.Write(<recipient _operation="update" _key="@id" lastUpdate={modifiedDate} id="12345" xtkschema="nms:recipient"/>);

    2 replies

    Jean-Serge_Biro
    Jean-Serge_Biro
    Level 10
    October 2, 2017

    Hello Tim,

    Please use getCurrentDate() in pure Javascript code, not GetDate().

    GetDate() is used in:

    • XML source schemas, see for example nms:recipient.created (NmsRecipient.tsCreated).
    • Query activity (expression editor on dates)
    • queryDef in Javascript activity

    But  there is an attribute lastModified in the schema nms:recipient (sql table column: NmsRecipient.tsLastModified), so I wonder what is LastUpdate field ?

    Or is it new field of ACS ? (I use Adobe Campaign v6.1.1).

    Regards
    J-Serge

      sambhavj5011451
      sambhavj5011451Accepted solution
      Level 2
      October 5, 2017

      Hi Tim,

      This works well.

      var modifiedDate = formatDate(new Date(), "%4Y-%2M-%2D %02H:%02N:%02S")

      xtk.session.Write(<recipient _operation="update" _key="@id" lastUpdate={modifiedDate} id="12345" xtkschema="nms:recipient"/>);

        Terms & ConditionsAccessibility statement

        Loading footer...