Date column

[peng wangParticipant]

When I used ICU format to recognize the date column, in the display option, the month can’t recognize. No matter what month you entered, the final display is “January” or “1”.

[dgteamModerator]

ICU formats are great, but they can be tricky.

Try “y.M.d”

Capitol D means day of year, not day of month.  Try with lower case d.  That is likely why you are always seeing Jan.

Capitol Y will give you the week year, and for some years will give the prior year to the actual calendar year, for the first few days of January.

But don’t use ‘m’ as that is minutes.

If you hover over the format statement a help should pop up showing a few of the common ICU codes.

For a full list: http://www.icu-project.org/userguide/formatDateTime

[dgteamModerator]

FYI — Here is how this looks with the format ‘y.M.d’

The pop-up box is shown from hovering over the Format box.

[peng wangParticipant]

Thank you for your reply. I got it.

[Author]

Posts