Find month and current year

[George]

I have a field "maturity_date" with the format mm/dd/yyyy and would like for the user to click on a button that corresponds to the month they are wanting a reports content searched/based on. I have a layout that has a button for each month of the year. I just want the report to contain maturity_date for the month and current year.

Thanks

[Ocean West]

When ever doing range reports I do reccomend the Troi Ranges Plugin

But this can be done with out the plugin. You would need to create

a global text field where you would list the numerical equivalent of the maturity_date

seperated by the "

[Vaughan]

Ya don't need no steekin' plugins!

Make a calculation field: "Maturity_Date_Monthname" = MonthName(Maturity_Date).

Make a calculation field: "Maturity_Date_Year" = Year(Maturity_Date).

Make a calculation field: "Maturity_Date_Search" = MonthName(Maturity_Date) & Year(Maturity_Date).

To use it, create a user interface with one global field for monthname -- gMonthName -- and another for year -- gYear. Put a pop-up list on the monthname and year global fields based on the values in the Maturity_Date_Monthname and Maturity_Date_Year fields respectively.

Create a script that first checks the global fields have a value selected, then

Enter Find mode []

Set field ["Maturity_Date_Search", gMonthName & gYear]

Perform Find[]

[George]

Thank you both!