INTERACT FORUM

More => Old Versions => JRiver Media Center 26 for Windows => Topic started by: MusicBringer on July 07, 2020, 05:37:22 pm

Title: Format of Date Tag - for Date Imported
Post by: MusicBringer on July 07, 2020, 05:37:22 pm
You are in complete control of how Dates are formatted for viewing in MC, but not how they are stored, and they are stored differently for different file types.

I would like to change the way Date Imported is displayed, please.
My view displays 30th December 1899 at 00:00:00 which Roderick said is known as the epoch date. Good.

I would prefer the display without the time suffix.
For example 07/07/2020 [and not 07/07/2020 09:29]
Title: Re: Format of Date Tag - for Date Imported
Post by: BigSpider on July 07, 2020, 05:45:12 pm
Surely the import date should have the actual time of the import not just the day-month-year, how would you know which file was imported first without the timestamp. If your view is showing 1899 I would suspect that your computer time is seriously wrong! Here is an example of mine.
Title: Re: Format of Date Tag - for Date Imported
Post by: RoderickGI on July 07, 2020, 06:23:08 pm
I agree with BigSpider. I use the time files were imported as much as the date.

Alas, there is no way to change the display format of [Date Imported] itself. Well, mainly because it is just a number. The formatting of dates is automatically handled by MC and depends a bit on the content and which date field it is.

Anyway, it is easy to fix the display of [Date Imported]. Just replace the field in the View with an Expression Column (https://wiki.jriver.com/index.php/Customize_List_and/or_Thumbnail_View), and use the Expression;

FormatDate([Date Imported,0], Date,)

You can even name the Expression Column "Date Imported" so as not to confuse, and the only visible change is the date format displayed.

Ref: https://wiki.jriver.com/index.php/Date_and_Time_Functions#FormatDate
Title: Re: Format of Date Tag - for Date Imported
Post by: MusicBringer on July 12, 2020, 05:40:59 pm
Hello RoderickGI, that's wonderful. That's just what I wanted. I am very happy.
thanks, 😊