>I have a process that I want to perform a monthly query against a table. The code should go something like:
>
>Count to m.thiscnt FOR between(tablename.datefield,firstdate1,seconddate2)
>
>Quite naturally I want firstdate1 to be the first of the current month when the process is ran and teh secondate2 to be populated with whatever the last date of teh current month when teh process is ran.
>
>Does anyone no how to do this?

see FAQ#7661