I am fairly new to FMP but not to programming. I have managed to figure out how to generate a monthly report based off of current date but I can't figure out how to use the dropdown calendar to do it. This is what I used for current date.

Enter Find Mode []

Set Field [iNVOICES:date_post;Month (Get ( CurrentDate ) )]

Perform Find []

The dropdown's name is xdate. I've tried to make

INVOICES:date_post = xdate

then Perform Find but it's not working.

Edited August 22, 200916 yr by Guest

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/179139/

Thanks for the post. That actually helped me refine another report I was generating.

Maybe my question wasn't clear. I would like to view every date within the month of the drop-down calendar.

If the calendar's month is July 2009, only show records from July 2009. I hope this is clearer.

It would be the same thing, except you would use the date in the 'xdate' field instead of current date. You haven't said what 'xdate' actually is - is it a global field?

"Global Field" was the key. I had xdate as a regular date field but once I changed it to global, it worked perfectly. THANKS!!