Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Have you tried using dollar sign expansion with the variables?
try referencing the variables like this:
$(vPast7Days) < $(vTodaysDate)
Tried this .... $(vPast7Days) < $(vTodaysDate) ... but it selects all the dates in the calendar instead of only the range I need. So puzzled
This works:
=Date>'$(vFrom)' and Date<'$(vTo)'
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
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.
This works also 🙂