Print

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

[ShayB]

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]

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]

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