Create, Collect, and Analyze Surveys and Web Forms
The base year is the earliest year for Month-Year Reports from the Design Menu - Preferences - Program Settings tab screen. The base year will be the first year searched for reports and charts. Your reports and charts may contain dates for many years. If you wanted to limit the dates to the last 3 years, then the base date year should be set to 3 years ago. Then only dates from the last three years would be used when calculating totals for reports and charts. Setting the base year can be used as a filter to remove earlier dates.
Create Survey Question
Collect Survey Responses
Filtered Analysis
Examples of 5 different date filters to be entered in the edit box are listed below. Dates are stored in the database in YYYYMMDD format, so the search for matches must be in the same physical order.
C = Calendar Month | 200810 | Year 2008 and Month 10 (October 2008) |
D = Day | 3 | 3rd day of any month |
F = Full Date | 20081225 | December 25, 2008 |
M = Month | 11 | November any year |
Y = Year | 1998 | 1998 |
Text is entered in the edit box. The first character must be the letter C, D, F, M, or Y. The second character is usually the mathematical symbol <, =, or >. If a mathematics symbol is not used, equal is assumed. The rest of the text is numbers indicating the date value to test for the filtered choice. The year must always have 4 digits. Days and months can be 1 or 2 digits. WISCO Survey Power will add the leading 0 to the entry for the search if necessary. The mathematics symbols <, =, and > are all valid. Some more examples:
F>20081225 | Date greater than December 25, 2008 |
Y<2000 | Year is less than 2000 |
M6 | if the month is June |
M5-7 | Months May to July, any year |
C=200708 | August 2007 |
Y2005-2008 | Years 2005 to 2008 (range) |