Skip to main content
1-Visitor
February 20, 2017
Solved

Is it possible to format date with milliseconds in TWX?

  • February 20, 2017
  • 2 replies
  • 3950 views

Hi,

I tried many options - none works, is there any quick way without parsing it manually?

DateString = "2017-02-20 15:04:39.543"

Option 1:

var sdf = "yyyy-MM-dd HH:mm:ss.sss";

var dateValue = parseDate(DateString, sdf);

Option 2:

var sdf = "yyyy-MM-dd HH:mm:ss.fff";

var dateValue = parseDate(DateString, sdf);

Option 3:

var sdf = "yyyy-MM-dd HH:mm:ss.fffZ";

var dateValue = parseDate(DateString, sdf);

Option 4:

var msec = Date.parse(DateString);

var dateValue = new Date(msec);

Best answer by qngo

It's almost option 1:

var sdf = "yyyy-MM-dd HH:mm:ss.SSS";

2 replies

qngo1-VisitorAnswer
1-Visitor
February 20, 2017

It's almost option 1:

var sdf = "yyyy-MM-dd HH:mm:ss.SSS";

aelgov1-VisitorAuthor
1-Visitor
February 21, 2017

Thank you very much!!!

Works like a charm...

I just wonder where exactly is it stated to use this format?

5-Regular Member
February 20, 2017

Assaf, just to check, what is the 'dateTimeFormat_Default' set to in your Default Localization Table? You can set that value to 'yyyy-MM-dd HH:mm:ss.SSS' for the datetime to be displayed/ rendered with milliseconds.