Using Date to Filter Data

Using Dates in the Where statement

public ShowOrders()
{
    From = Orders;
    Where.Add(Orders.OrderDate.IsGreaterOrEqualTo(new Date(1997, 1, 1)));
} 

Using date in the Between statement

Where.Add(Orders.OrderDate.IsBetween(new Date(1996, 1, 1), new Date(1996, 12, 31))); 

An other example:

var start = new Date(1996, 1, 1);
Where.Add(Orders.OrderDate.IsBetween(start,start.EndOfYear)); 

---

• Exercise Date in Filter

---

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