cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Wrong date's format

SOLVED
Highlighted
Aquamarine

Wrong date's format

Hello!

 

I'm trying to correctly display the date in the grid column. My date format is this (months go first):

 

2.PNG

 

In the grid properties I set the appropriate format:

 

1.PNG

 

But in mashup the day of the week is displayed instead of number, and the year isn't displayed at all:

 

3.PNG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Wrong date's format

Hello @Mr_Henry_M,

 

Advanced Grid bundles Moment.js, which has its own unique syntax: https://momentjs.com/docs/#/displaying/

 

In your case correct format will be "MM.DD.YYYY H:mm:ss".

 

2019-11-10 15_37_09-Moment.js Sandbox - JSFiddle.png

 

/ Constantine

View solution in original post

5 REPLIES 5

Re: Wrong date's format

Is that Grid Advanced?

Re: Wrong date's format

Yes

Re: Wrong date's format

Doesn't the year need to be YYYY ? 

 

Re: Wrong date's format

Hello @Mr_Henry_M,

 

Advanced Grid bundles Moment.js, which has its own unique syntax: https://momentjs.com/docs/#/displaying/

 

In your case correct format will be "MM.DD.YYYY H:mm:ss".

 

2019-11-10 15_37_09-Moment.js Sandbox - JSFiddle.png

 

/ Constantine

View solution in original post

Re: Wrong date's format

Thanks!

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________