Print

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

[TomNKY]

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?

[MrC]

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

[TomNKY]

Fantastic !!!

It worked great.

Thank you

[TomNKY]

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

[MrC]

I have it backwards.  Replace >= with <.

[TomNKY]

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