INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Can the "Date" field format be changed to yyyy/mm/dd?  (Read 1160 times)

lalittle

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 3964
Can the "Date" field format be changed to yyyy/mm/dd?
« 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
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9124
Re: Can the "Date" field format be changed to yyyy/mm/dd?
« Reply #1 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.

robydago

  • Citizen of the Universe
  • *****
  • Posts: 518
Re: Can the "Date" field format be changed to yyyy/mm/dd?
« Reply #2 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.
Logged

lalittle

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 3964
Re: Can the "Date" field format be changed to yyyy/mm/dd?
« Reply #3 on: March 28, 2007, 07:13:26 am »

Thanks guys.

Larry
Logged
Pages: [1]   Go Up