Select in field selects all when filter is not hit

[#1]

Hi all,

I have a "Select in Field" action in a post reload event. It selects the current day with the following search string:

=Date(Today(),'DD/MM/YYYY')

Sometimes it happens that I have no data for that day and the filter is not hit. When this happens it selects all data and exports them from the beginning of time.

Is there a way to avoid this behaviour or at least intercept it someway?

Thanks in advance.

[Anonymous]

Hi,

you should use a calendar table with all days of the year.

Link this calendar to your data table. Then apply the "Select in Field" action on the date field of the calendar.

Then the filter will work and you will have no data as you want

[tresesco]

Could you post a sample that demonstrates the issue?

[antoniotiman]

Hi Nicola,

Maybe

Assuming You have data for <=Today()

Date(Max({1} YourDateField),'DD/MM/YYYY')

Regards,

Antonio