Exercise - Using Date to Filter Data

1. Right-Click on the Exercise folder and add a new UIController named ShowOrders.
2. Define the Orders table at the beginning of the controller class.(drag and drop it, holding the Shift key just before the drop).
3. Using the Class Outline Open the Form Designer:
4. Add a grid to the Form.
5. Add the following columns to the grid:
   1. OrderID
   2. OrderDate
   3. ShipVia
   4. ShipName
   5. ShipCity
6. Save changes to Git.
7. Build and test.
8. Go back to the controller of ShowOrders:
9. Add a Where to display only orders from January 1996 up to the end of June 1997.
10. Save changes to Git.
11. Build and test.

• Exercise Date in Filter results

---

Help us improve, Edit this page on GitHub
or email us at info@fireflymigration.com