INTERACT FORUM
More => Old Versions => Media Center 13 (Development Ended) => Topic started by: park on December 08, 2008, 09:01:50 am
-
Hi all,
I'm trying to make an expression that will show me all my night photos. I created a custom field with the following calculated data:
If([Time]>17:00,1,0)
But obviously it doesnt work, since there is no field called "Time" in MC. Does anybody know how to strip the time part out of [Date] field?
-
Currently:
IsEqual(Mid(FormatDate([Date, 0], filename), 9, 2), 17, 6)
In build 13.0.87 and later:
IsEqual(FormatDate([Date, 0], hour), 17, 6)
-
Thanks Matt.
I've pasted in the latter one and will wait for the next build.
-
ahhh, nice one.
Thank you.
-
It's a useful field to have. I recommend putting it in image view's quickie's pane by default.
-
less useful perhaps, but just as clever, if you put:
formatdate(now(),dddd dd//MM//yyyy) padnumber(formatdate(now(),hour),2):padnumber(formatdate(now(),minute),2)
in the player display, it displays the current day, date and time!!
(http://www.theganghut.co.uk/pics/ia/13/dateandtimedisplay.jpg)
-marko.