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

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Wrong date's format

Mr_Henry_M
14-Alexandrite

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

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
posipova
20-Turquoise
(To:Mr_Henry_M)

Is that Grid Advanced?

Mr_Henry_M
14-Alexandrite
(To:posipova)

Yes

ckaminski
13-Aquamarine
(To:Mr_Henry_M)

Doesn't the year need to be YYYY ? 

 

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

Mr_Henry_M
14-Alexandrite
(To:Constantine)

Thanks!

Top Tags