topic Re: parseDate is not working in ThingWorx Developers

parseDate is not working

AZ_10002894 — Tue, 25 Jan 2022 22:12:38 GMT

Hello, need some help.

I want a service Datetime output(string works) with ""MM/DD/YYYY hh:mm" format, I used dateFormat and parseDate to try to achieve this, but output shows other format, I check with postman, and I looks similar, please help.

postman

Re: parseDate is not working

bchaudhary — Wed, 26 Jan 2022 09:18:08 GMT

Hi @AZ_10002894 ,

Kindly check the following article on parsedate in Thingworx:

https://www.ptc.com/en/support/article/CS219448

Let me know if it doesnt solve your issue.

Regards

Bhawna

Re: parseDate is not working

AZ_10002894 — Wed, 26 Jan 2022 16:37:52 GMT

Hello Bhawna,

that was exactly example that I used, just eliminate sdf var, using the string directly in parseString and parseDate.

//Standard ThingWorx Date Format var sdf = "MM/DD/YYYY hh:mm"; // dateValue:DATETIME var dateValue = new Date(); // dateFormat(dateValue:DATETIME,dateFormat:STRING):STRING var formattedDate = dateFormat(dateValue, sdf); // parseDate(stringDate:STRING,dateFormat:STRING):DATETIME var result = parseDate(formattedDate, sdf);

but, that doesnot works, at least for me, could you run this code on a thingworx service?, that doesnt change the output format.

Re: parseDate is not working

bchaudhary — Thu, 27 Jan 2022 08:55:03 GMT

Hello @AZ_10002894 ,

why don't you get the output as string and provide formatted date into output instead of parsing it?

// dateFormat(dateValue:DATETIME,dateFormat:STRING):STRING
var formattedDate = dateFormat(dateValue, sdf);

// parseDate(stringDate:STRING,dateFormat:STRING):DATETIME
//var result = parseDate(formattedDate, "MM-dd-yyyy HH:MM");
var result = formattedDate;

pls let me know if you need further assistance on this or if it doesn't meet your use case.

Regards

Bhawna