In this line of code:

```
sql = "Select CustomerNumber,Surname,Villa,
         Village,Suburb,BookedinDate,BookedInOrder 
         FROM Customers WHERE 
         (BookedInDate >= @StartPeriod And BookedInDate <= @EndPeriod )"

```

where

```
cmd.Parameters.AddWithValue("@StartPeriod", StartPeriod)
cmd.Parameters.AddWithValue("@EndPeriod", EndPeriod)

```

and 

```
StartPeriod = "01-09-2017"
EndPeriod = "01-15-2017"

```

The datatable contains a record with a BookedInDAte value of "01-09-2017" but is not being picked up in the above Sqlite string.

Any help would be appreciated
Brad