How to Create a Panel with Date Criteria Selection

In this tutorial, we will show how to use and add a date criteria selection and how will it work on individual panels.

1. Open a Panel Settings record. In this sample, let us open the record from Dashboard through the Panel Options menu.
   
2. Select any available predefined values of Date Condition and a Date Variable.
3. Declare the clause Where @DATE@ or Where #DATE# manually on the Query field. You can manually enter it in the Query field or you can use the Query Builder screen.
   
   When using the Query Builder screen, enter a value of “1” on Expression and a value of “=1” in Criteria. This will result to have a clause of “Where 1 = 1” on the statement. Clicking the OK button will reflect automatically the Where @DATE@ on the Panel Settings > Query field.
   
4. Select any available pre-defined values of Date Condition and a Date Variable.
5. Select the appropriate Date Field for the date criteria.
   

6. Save and close the Panel Settings record. The panel on the Dashboard will be automatically refreshed, and will now display the Date Filter field on the upper right-hand corner. This combo box list will show the same predefined dates on the Panel Settings > Date Condition field.
   

   As you change the selected date filter, the panel will automatically refresh and display records respectively.