Change Date format

[jbellomo]

Is there a way to change the date format in the Media browser column? Right now it is YYYY-MM-DD I would like to change it to MM-DD-YYYY

[R Neil Haugen]

The reason the date format is displayed that way is that is the way all date data needs to be formatted for proper sorting. And ... I think that's the only way date data is displayed in that panel.

Neil

[Mariam Hovhannesyan]

What's the difference in yyyy mm dd and mm dd yy in both cases it will probably have the same following in case you didn't shoot for several years.

[jbellomo]

Because we look at dates that way not year first

[excited_Genie16B8]

That's how it's recorded in the media file.  You can't change that.

[jbellomo]

Every thing in the media browser date column is like that , it doesn't matter on how it is recorded.

[excited_Genie16B8]

There are no user adjustments for this.

[R Neil Haugen]

All computers store dates in that format ... any time you see a different format displayed, it's because of adding in code to the app to display other than as stored. I think the engineering staff for PrPro just default to the standard display of the built-in format. YMD format of course goes from the general to the specific, the natural sort order.

It's not been the normal in the past for say North America, but over the last 30 years has become far more common, including most government forms. Simply because it's more 'standard' if everything shows one format. In our portrait studio, all our client images are in folders within folders, all built on y-m naming so they sort correctly. I've gotten used to the format, though I still think d-m-y is 'prettier'.

Neil

[sarahl39753622]

My problem is that in the Acrobat Reader app on my MacBook, the date format is how I want it when I view "Recent" (i.e. DD/MM/YYYY) but in the Document Cloud it's showing MM/DD/YYYY.

If anyone knows how to sort the date format so that it's DD/MM/YYYY throughout the app, that'd be great for me too!

[Mike Dziennik]

Its better for everyone if we only use YYYYMMDD for the reasons listed above.

DDMMYYYY was acceptable before computers.

MMDDYYYY is just plain wrong, people should stop using it and it has no justification.

[sarahl39753622]

The dates are probably stored in the backend in the format YYYYMMDD but they should be displayed to the end user in the end user's locale, and they should be the same format whichever list the end user is viewing within the same app!

The locale for the UK is en-GB (usually d mmmm yyyy or dd/mm/yyyy) and I expect all lists within Acrobat Reader to display the dates in that locale, but some do and others don't.

BTW - there are many different formats for dates for different locales around the world, and none of them are "wrong" in respect to the front end/user interface, e.g:

yyyy-mm-dd

dd/mm/yyyy

dd.mm.yyyy

d mmmm yyyy

dd/mm/yy

Thanks,

Sarah

[Stan Jones]

I just realized how fun this topic is. I was nodding my head in agreement to this and that, and then realized that none of it is so definite.

Dates are often "stored" on computers as numbers - e.g. Excel - and then the applications format them in whatever way the programmers determine. Sometimes the user can control the format and other times not. And other times the date information is stored as ASCII data, and I suspect this is true of camera data. But a program must read the data as date data, so it can just as easily display in any way the programmers want.

We really don't know how PR stores dates, do we? For example, from information in the project file, I believe it uses timecode based on "ticks," and calculates and displays timecode as it is needed. In the Media Browser, the date may well be picked up from the source files (not any PR cache etc), and, as described above, it is displayed as yyyy-mm-dd HH:mm:ss:mmm. In the project panel, the date display is m/d/yyyy hh:mm:ss AM/PM.

Also, a program can display timecode one way, and sort it based on the actual date value.

I assumed in a different date discussion, that the PR programmers would set the UI to pick up the date formatting the user has set in the OS.