Listbox Date search string problem

[#1]

I have created these variables ...

LET vTodaysDate = today();
LET vTodaysDate = Date(vTodaysDate);
LET vPast7Days = Date(vTodaysDate-7);

Have a listbox for a date field.  When I input this >=01-07-14 <07-07-14 in the list box search I get the dates in between.  I want to do the same but using the variables above >=vPast7Days <vTodaysDate so that then I can create a bookmark, but it will not work with the variables.

Have tried many different formats how to input the variables but still not working.  How should it be done?

[m_woolf]

Have you tried using dollar sign expansion with the variables?

[#3]

try referencing the variables like this:

$(vPast7Days) < $(vTodaysDate)

[#4]

Tried this  .... $(vPast7Days) < $(vTodaysDate) ... but it selects all the dates in the calendar instead of only the range I need.  So puzzled

[tresesco]

This works:

=Date>'$(vFrom)' and Date<'$(vTo)'

[aveeeeeee7en · Accepted solution]

Hi Alex

I advice you to create a Button

Add Action Select in Field

Field Name:

Your Date Field

Search String:

='>=$(=date(today()-7))' & '<$(=date(today()))'

Kindly see the Attachment.

Regards

Aviral Nag

[#7]

Although not exactly what I wanted but this works well enough for me.  This forum is an excellent resource thanks to you guys.  Keep it up.

[#8]

This works also 🙂