INTERACT FORUM

Please login or register.

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

Author Topic: Smartlist Date field befoe 'Today' or 'Now'  (Read 1576 times)

TomNKY

  • Recent member
  • *
  • Posts: 25
Smartlist Date field befoe 'Today' or 'Now'
« on: September 19, 2013, 09:11:16 am »

I'm working on creating Timecapsule Clips for my grandkids and I have a smartlist for each of them on their parent's MC. The clips have a date field I called deliver where I put the day they should get their clip. I had in mind saying Deliver is before 'Today' or 'Now' or some time designator that I'd think exists in the data base somewhere however we have and empty edit which if I hard code a date does exclude future clips. But I need some trick to pull this off. Are there any system designators for a changing date?
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Smartlist Date field befoe 'Today' or 'Now'
« Reply #1 on: September 19, 2013, 10:56:55 am »

Is your Deliver field created as Type = Date?

If so, you can use this (untested) custom expression-based query in your samrtlist (paste it into the dialog that appears when you press the Import/Export  button):

   [=Compare([Deliver,0], >=, Now())]=1
Logged
The opinions I express represent my own folly.

TomNKY

  • Recent member
  • *
  • Posts: 25
Re: Smartlist Date field befoe 'Today' or 'Now'
« Reply #2 on: September 19, 2013, 01:28:56 pm »

Fantastic !!!

It worked great.

Thank you
Logged

TomNKY

  • Recent member
  • *
  • Posts: 25
Re: Smartlist Date field befoe 'Today' or 'Now'
« Reply #3 on: September 19, 2013, 01:44:36 pm »

OOps .. reveals the ones yet to come.... rather than the ones expected to deliver .. trying to suss that out

gotta look up that Compare() function
Logged

MrC

  • Citizen of the Universe
  • *****
  • Posts: 10462
  • Your life is short. Give me your money.
Re: Smartlist Date field befoe 'Today' or 'Now'
« Reply #4 on: September 19, 2013, 01:46:35 pm »

I have it backwards.  Replace >= with <.
Logged
The opinions I express represent my own folly.

TomNKY

  • Recent member
  • *
  • Posts: 25
Re: Smartlist Date field befoe 'Today' or 'Now'
« Reply #5 on: September 19, 2013, 01:55:16 pm »

I got it now.. and it helps if I had named the clips inside the playlist group logically so I keep straight which ones are which date ;-)

Thanks again

Logged
Pages: [1]   Go Up