Wrong date's format

[Mr_Henry_M]

Hello!

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

In the grid properties I set the appropriate format:

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

[posipova]

Is that Grid Advanced?

[Mr_Henry_M]

Yes

[ckaminski]

Doesn't the year need to be YYYY ? 

[Constantine · Accepted solution]

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".

/ Constantine

[Mr_Henry_M]

Thanks!