Drop Down Calendar Problem

[GP inc.]

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, 2009 by Guest

[comment]

See if this helps:

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

[GP inc.]

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.

[comment]

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?

[GP inc.]

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