INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

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

ShayB

  • Junior Woodchuck
  • **
  • Posts: 97
question: display/format the time values (hour,minute,seconds)
« 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
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8967
Re: question: display/format the time values (hour,minute,seconds)
« 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

  • Junior Woodchuck
  • **
  • Posts: 97
Re: question: display/format the time values (hour,minute,seconds)
« 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
Logged
Pages: [1]   Go Up