The Date format problem with MS-Access DB

[Praveen 123]

This is the Select query that i am using while developing ASP.Net app using VB.Net My EventDate is in General Date format.But gDate is in Short Date format.So query not produsing any out put. Dim gDate As DateTime = txtDate.Text.Trim() SelectQueryText = "SELECT Distinct UserID,EventDate FROM History WHERE Dept='" + lstDept.SelectedValue.Trim() + "'AND EventDate=" + gDate + "" What is the currect query to get the OutPut?

Praveen.K System Engineer Graviton Technologies Pvt.Ltd

[Sylvester george]

change EventDate as shortdate then compare

Regards, Sylvester G Senior Software Engineer Xoriant Solutions sylvester_g_m@yahoo.com

[Praveen 123]

Sir, Actually i dont ve the permission to change the format of EventDate in DB...Then what i should do?Is there any provision to change the format of record at rub time?

Praveen.K System Engineer Graviton Technologies Pvt.Ltd