Topic: question: display/format the time values (hour,minute,seconds) (Read 1145 times)

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

marko · « **Reply #1 on:** January 30, 2008, 03:16:44 pm »

In this post, 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?

ShayB · « **Reply #2 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

INTERACT FORUM

Author Topic: question: display/format the time values (hour,minute,seconds) (Read 1145 times)

ShayB

question: display/format the time values (hour,minute,seconds)

marko

Re: question: display/format the time values (hour,minute,seconds)

ShayB

Re: question: display/format the time values (hour,minute,seconds)