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

Facing issue while updating date column in schema

ulkeshc26364810
Level 2
Level 2

Hi Team,

We are fetching data from api server through javascript, but while updating that data into schema its throwing error for date column.

We given date as datatype for date column.

We are getting date in below format,

"MEMBER_START_DT_CURR":"13\/05\/2017"

kindly find screenshot for the same, below are the sample code we written for updating into schema.

xtk.session.Write('<tempTable _operation="insert" member_start_dt_curr=" '+MEMBER_START_DT_CURR+' " xtkschema="apl:tempTable"/>');

date.PNG

1 Accepted Solution
Vapsy
Correct answer by
Employee
Employee

Hi Ulkesh,

Try converting the MEMBER_START_DT_CURR to "2017-05-13 00:00:00.000Z" and see if it helps.

Regards,
Vipul

View solution in original post

1 Reply
Vapsy
Correct answer by
Employee
Employee

Hi Ulkesh,

Try converting the MEMBER_START_DT_CURR to "2017-05-13 00:00:00.000Z" and see if it helps.

Regards,
Vipul

View solution in original post