Skip to main content
1-Visitor
November 7, 2019
Solved

Wrong date's format

  • November 7, 2019
  • 3 replies
  • 2617 views

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

 

 

 

Best answer by Constantine

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

3 replies

20-Turquoise
November 7, 2019

Is that Grid Advanced?

1-Visitor
November 8, 2019

Yes

5-Regular Member
November 8, 2019

Doesn't the year need to be YYYY ? 

 

18-Opal
November 10, 2019

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

1-Visitor
November 11, 2019

Thanks!