Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Session.Write: Insert date

timg96297954
Level 2
Level 2

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

1 Accepted Solution
sambhavj5011451
Correct answer by
Level 2
Level 2

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

View solution in original post

2 Replies
Jean-Serge_Biro
Community Advisor
Community Advisor

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
Correct answer by
Level 2
Level 2

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

View solution in original post