将linq日期转换为短日期

Question

我在Sale表中有以下查询，并希望按短日期进行过滤。

Dim query = From c In db.Sale Where c.TRAN_DATE=TranDateParam
            Group By c.TRAN_DATE Into Total_Payment = Sum(c.PAYMENT),Discount_Amount = Sum(c.DISCOUNT) _
            Select Total_Payment, Discount_Amount, TRAN_DATE

-我的c.TRAN_DATE值包含时间。例如:"2013-05-01 10:09:49.107"
-我的TranDateParam值是短日期格式。例如:"2013-05-01"

因此我不能比较c.TRAN_DATE=TranDateParam。我尝试了许多方法将c.TRAN_DATE转换为短日期，但没有成功。

我尝试了下面的方法，但是失败了:

c.Tran_Date.ToString("dd-MM-yyyy")
c.Tran_Date.Value.ToShortDateString()
CDATE(c.Tran_Date)

我该如何解决这个问题?由于

Answer 1

问题已修复。我只是改变我的查询如下:

Dim query = From c In db.Sale Where c.TRAN_DATE= CDate(TranDateParam) _
            Group By c.TRAN_DATE Into Total_Payment = Sum(c.PAYMENT),Discount_Amount = Sum(c.DISCOUNT) _
            Select Total_Payment, Discount_Amount, TRAN_DATE