Date range in Select in Field action is not working

[sivarajs]

Hi,

I am facing issue in selecting data range from select in field action. I have start and end date, am using select in field in button action. After select dates and click on button, the functionality is not working. I have also tested by giving single date in search string, its working but for range not working.

Regards,

Sivaraj

[sushil353]

Hi,

what expression are you using in action.

[sushil353]

use something..

='>=' &$(startdate)&'<=' $(endDate)

in the action >search string

HTH

sushil

[Anonymous]

I don't think it's possible setting a range of dates in a field.

The only way that i've found to do a filter with a range of dates was creating input fields for start date and end date, setting the values in variables and calculating the condition in every expression that I want to filter with that range of dates.

Hope it helps.

Gabriel

[sivarajs]

yes..am using in it same way

[jpenuliar]

what does your formula look like if you show it on a textbox?

could it be that your date variable format is the issue?

maybe $(=date(startdate)) will work

[Shubham_Deshmukh]

ANy idea about text box search string?

I am having same issue for text box action, but it is not working