Error parseDate - Invalid format: "1488722317000" is malformed at "7000"

aelgov — Sun, 05 Mar 2017 14:16:53 GMT

Hi,

I don't know what went wrong but I'm trying to do something very simple.

I have infotable with DateTime column, I want to run over it and parse the date.

I get an error for the following code:

var tableLength = result.rows.length;

for (var x = 0; x < tableLength; x++) {

var row = result.rows;

//"yyyy-MM-dd HH:mm:ss.SSS";

var dateFormat = Resources["RuntimeLocalizationFunctions"].GetEffectiveToken({token: "dateTimeFormat"});

var dateValue = parseDate(row.DateTime, dateFormat);

}

I also tried to do toString to row.DateTime and it didn't work

Re: Error parseDate - Invalid format: "1488722317000" is malformed at "7000"

ankigupta — Mon, 06 Mar 2017 04:28:55 GMT

Hi Assaf Elgov,

Please try using the ThingWorx inbuilt function dateFormat.

// dateValue:DATETIME
var dateValue = new Date();
// dateFormat(dateValue:DATETIME,dateFormat:STRING):STRING
var formattedDate = dateFormat(dateValue, "yyyy-MM-dd HH:mm:ss.SSS");

It worked fine for me.

Do let me know if you still face any issue.

Thanks,

Ankit Gupta

topic Re: Error parseDate - Invalid format: "1488722317000" is malformed at "7000" in ThingWorx Developers

Error parseDate - Invalid format: "1488722317000" is malformed at "7000"

Re: Error parseDate - Invalid format: "1488722317000" is malformed at "7000"