How do I search between dates (variables) using Visual Basic Linq to sql?
Posted on 2010-09-21
I have two dates stored as strings:
dim x as string = '2010/9/9'
dim y as string = '2010/8/8'
I have the following LINQ TO SQL statement that works perfectly fine:
Dim listTrans As List(Of TransactionData) = _
(From trans In db.TransHeaderTables _
Select New TransactionData With _
.TransId = trans.TransId.ToString, _
.EncryptionTCN = trans.TCN, _
.EncryptionORI = trans.EncryptionORI _
What I need is to add in a way to do a WHERE trans.CompletedDate between X and Y. Can someone modify the statement above? Also, I'd love a separate modified statement above that can grab the records within the last X days.