INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: lalittle on March 28, 2007, 05:02:13 am

Title: Can the "Date" field format be changed to yyyy/mm/dd?
Post by: lalittle on March 28, 2007, 05:02:13 am

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

Title: Re: Can the "Date" field format be changed to yyyy/mm/dd?
Post by: marko on March 28, 2007, 05:11:51 am

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.

Title: Re: Can the "Date" field format be changed to yyyy/mm/dd?
Post by: robydago on March 28, 2007, 06:34:05 am

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.

Title: Re: Can the "Date" field format be changed to yyyy/mm/dd?
Post by: lalittle on March 28, 2007, 07:13:26 am

Thanks guys.

Larry