Set a variable to include everything up to yesterday's date.

[shinnickr]

Hi,

I am hoping to set a variable to include every day up to yesterday.  My field starts in 2012 and I want to include every day from 2012 -  yesterday.  I have a variable for yesterdays date 'Date(Today() -1)' but I want to include everything up to and including that date.  I don't know if I'll need some set analysis or if there's a function that would help me with that so I would appreciate any help that can be given.

Thank you very much.

[sunny_talwar]

Here are some ideas

[shinnickr]

Oh I like the textbox showing the range, that is a great idea.  I appreciate it!  Thanks Sunny, you're the best! 😃

[shinnickr]

Thanks Irene!  I truly appreciate the help.  I did end up finding a way to do what I wanted, courtesy of Sunny.  I'm using ='=[Service Date] < Today()' and it is accomplishing what I was looking to do.

Unfortunately, in my current selections box it shows the formula and it could be confusing to the end user.  I've looked at a couple different solutions but don't have anything too great.  If you have any ideas on how to change the displayed formula I'd love to take a look!