I have a datatype datetime that stores a ledger date. It does also store the time of the transaction, so
15-10-2008 13:45 etc
I need to get all transactions between 2 dates ignoring the time, so
WHERE [ledgerdate]>= @FromDate AND
Where @FromDate are passed in format 01-10-2008 and 30-10-2008, no times
How do I make it ignore the time in the [Ledgerdate]?