Want to create a script to print a Profit & Loss statement for any given month without having to enter find mode and selecting the "from / thru" dates.

i.e. If the month is August, find all records from 8/1...8/31

if it is indeed August and so on depending on what the current date is.

Try:

Enter FInd Mode []

Set Field [ Datefield ; Let ( t = Get (CurrentDate) ; Date ( Month(t) ; 1 ; Year(t) ) & ".." & Date ( Month(t) + 1 ; 0 ; Year(t) ) ) ]

Perform Find []

thanks for your help. I am not sure what "(t)" stands for in your script?

the calculation does not appear to be working...

T is just a place holder; a variable name. It is like saying let X = something.

The calculation is correct. If it isn't working you're doing something different from the instructions provided.

Edited August 12, 201015 yr by Guest

That calc will only work in FMP 11... earlier versions do not support the calc engine in Find mode.

I think the OP is using FMP 9.0

It will work just fine.

Yes, you're absolutely right it will: I was thinking of the calc engine in the Enter Find Mode [ restore ] step, which is new in FMP 11.

"We have normality. Repeat: we have normality. Anything you still can't cope with is therefore your own problem." -- HHGG

ALL YOUR DATABASE ARE BELONG TO US.

FOR GREAT JUSTICE!