Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a month selected, for example September and I have a table with dates, for example 01/02/10 and 01/10/10.
I want to do a button that if i have push this button, in the table has to appear 01/10/10 because i have selected the September month and i want that in the table has dates>=selected month.
I don´t know how to do it with the graphics "button"
Use a Trigger, Select in Field. Field should be your date field. In the search string, something like:
='>=MakeDate(2010, $(=Only(Month)))'
You may need to convert the Month field to a number to work in the MakeDate() function. You can use Num for that. Plus, this will only select greater than the month in 2010, you may want to handle that year a little more dynamically.
It also helps to put some information about your question as your topic. That way people have an easier time identifying what kind of help you need.
I don't understand how I can do a trigguer
It's on the Actions tab of your Button properties.
You can also find more information in the Reference Manual. It's page 725 or 196 of Book II in the version I have under the heading Actions.
Hi,
Besides using a dollar expansion if needed, syntax would look like
='>=$(=MakeDate(Year, Month))'
Regards