Print

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

[MusicBringer]

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]

[BigSpider]

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.

[RoderickGI]

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, 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

[MusicBringer]

Hello RoderickGI, that's wonderful. That's just what I wanted. I am very happy.
thanks, 😊