INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: ShayB on January 30, 2008, 01:29:20 pm

Title: question: display/format the time values (hour,minute,seconds)
Post by: ShayB on January 30, 2008, 01:29:20 pm

Hi everyone,

Is there a way to extract the time values from the [date] field?
I would like to be able to filter lists with these values (ditinguish between dates that  contain date+time or just dd/mm/yy values)

Thanks,
Shay

Title: Re: question: display/format the time values (hour,minute,seconds)
Post by: marko on January 30, 2008, 03:16:44 pm

In this post (http://yabb.jriver.com/interact/index.php?topic=36437.msg248529#msg248529), I describe how I extracted the time values from the [date (filename friendly)] field for use in sorting photographs.
Does that help you at all, or do you need something else?

Title: Re: question: display/format the time values (hour,minute,seconds)
Post by: ShayB on January 30, 2008, 04:38:37 pm

Thanks Marko,

It's the start. I encapsulated your time formula with "if":
if(mid([date (filename friendly)],9,-1) = 0,1,0) now I can filter the entries with time information.

The strange thing is that I expected a value of "1" for entries with dates only (no time) because the condition is on the time part only. but in reality a value of "1" is displayed for entries with time information...
I tried to change the equation like this:
if(mid([date (filename friendly)],9,-1) ,1,0)
and now it works as expected.
seems as though the value of 6 zeros is not "0"


Shay