Page History

...

1. Open a Panel Settings record. In this sample, let us open the record from Dashboard through the Panel Options menu. 
   Image Modified
2. Declare the clause Where @DATE@ or Where #DATE# manually on  on the Query field. You can manually enter it in the Query field or you can use the Query Builder screen.
   Image Removed
   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.
   Image Removed 
   Image Added
   
   
3. Select any available pre-defined values of Date Condition and a Date Variable.
4. Select the appropriate Date Field for the date criteria.
   Image Modified

5. 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.
   Image Modified

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

...

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

...

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