Print

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

[park]

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?

[Matt]

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)

[park]

Thanks Matt.
I've pasted in the latter one and will wait for the next build.

[marko]

ahhh, nice one.
Thank you.

[park]

It's a useful field to have. I recommend putting it in image view's quickie's pane by default.

[marko]

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



-marko.