by COBS Tech Support » Mon Aug 14, 2006 3:29 pm
Load your report/form into the Visual Builder editor. Then from the main menu select Edit|Form Properties. Click on the Questions tab button. Select each question in turn and press Edit.
For the start date the script inside the Variable Declaration box should look like this:
Declare Answer1 Type Date
Answer1 := MonthStart(DateFromMonth(Today(), -1))
(If the variable name in Result In is not 'Answer1' change the above references from 'Answer1' to whatever matches the contents of this field.)
For the end date the script inside the Variable Declaration box should look like this:
Declare Answer2 Type Date
Answer2 := MonthEnd(DateFromMonth(Today(), -1))