Hi Guys

I have a problem perfoming a find in FM7.

I created a database in FM 6 for entering all my invoices.

I created a script that would let me see how much I had invoiced in any month and year. Within the script I used a "Set Field" function for the month and year. I had the 'Report Month' as a drop down menu with a value list laid ouy as follows.

1 - Jan

2 - Feb

3 - Mar..etc

In FM6 when I set this Global field as a number the find criteria would only pick up the number part of the field. Now in FM7 the find returns no found records. If I edit the value list to show the number only the find works. Is there another way I have to layout the value list in FM7 ?

Does anyone have a better way of finding records in a given month and year by performing a script?

Thanks a bunch

Steve

In the invoice date field on the find layout, you could enter the range you want, like 01/01/2004...01/31/2004 (for January). You could also write a script with buttons on the layout for each month; this would save you from entering date ranges. Even better would be to set up another related file with summary fields from the invoice table.

Number fields behave differently in 7. See here for more detail. Try using GetAsNumber(globalnumberfield) in your Set Field step.