Show Dates Less Than or Equal to Selection

[#1]

Hi All,

I have a date field [LastModifiedDate]. When i make a selection on this feild it drills the data down to the specific dates that are selected.

What i want to do is to be able to show all dates less than of equal to the dates i have selected.

e.g. when i select 16Mar i want it to show all record with a [LastModifiedDate]<= 04Jan.

The way i have it at the moment it only shows data equal to 04Jan

I have attached a sample of the data........

Thanks in advance

James

[#2]

Sorry to butt in but I think this might be an easier solution. Create a data island as mentioned earlier (but use distinct to only load one occurence of each duplicate value)

DateSelection:
LOAD DISTINCT
[Last Modified Date] AS [Selection Last Modified Date]
Resident Table;

Create a list box for [Selection Last Modified Date]

Settings>Document Properties>Triggers>add 'OnSelect' action to field event trigger for [Selection Last Modified Date]>Add action 'Select in field' with field [Last Modified Date] and search string

=if(not(isnull([Selection Last Modified Date])),'<=' & [Selection Last Modified Date])

Regards,

Gordon

[#3]

Thanks for that technique Gordon. Am glad there is an alternative to Advanced Search and button.

[#4]

Got it working.... your example helped a lot....

[#5]

Another Great Solution.... Much appreciated guys!!!

[#6]

You can make a button with a select field action.  Then pick the "dates field" you're using and use this as the search string

='=dates field<=today()'

Use the expression exactely as above, replacing dates field with your field name and when you click the button it will highlight all dates less than or equal to the current.

[#7]

Thanks, Brandon.  This is exactly what I needed.