Session.Write: Insert date

timg96297954

02-10-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

sambhavj5011451

04-10-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"/>);

Answers (1)

Answers (1)

Jean-Serge_Biro

MVP

02-10-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