Current Month

[Chris L]

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.

[comment]

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 []

[Chris L]

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

[Chris L]

the calculation does not appear to be working...

[bruceR]

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

[Vaughan]

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

[comment]

It will work just fine.

[Vaughan]

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

[comment]

ALL YOUR DATABASE ARE BELONG TO US.

[Vaughan]

FOR GREAT JUSTICE!