Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[lalittle]

Is there any way to change the format of the "Date" field in MC?  It currently displays as "m/d/yyyy."  I've become accustomed to using and seeing it as "yyyy/mm/dd," so if possible I'd like MC to display it this way as well (just for the sake of consistency, which is less confusing in certain situations.)  Is this possible?

Thanks,

Larry

[marko]

formatdate([date,0],yyyy//MM//dd)

you can use it as an expression based column, an expression based pane, or as a calculated library field in its own right.

I'm not 100% certain, but I've a feeling that MC uses the default system format for displaying dates, so it might be worth your while trying that out too and see if that gets you more desirable results?

-marko.

[robydago]

MC relies on XP settings:
if you want that date format to be your default in MC (and as a side effect everywhere else) and go to your XP "control panel" > "regional and language option" > "customize" > "date" and do whatever you like

roberto d.

[lalittle]

Thanks guys.

Larry