Member Avatar for carlakawill

Hi All

I am trying to query my access DB using a C# windows app and one of the fields is a type date/time. I have set the field to general date but when i run this query it displays the date and time set to 00:00:00. How can i just get the date and similarly just the time?

this is my query

("SELECT Staff.FName,Staff.SName, Shift.SDate, Shift.SStart, Shift.SEnd FROM Staff INNER JOIN Shift ON Staff.[StaffID] = Shift.[StaffID] WHERE Shift.SDate >=#" + tbStartDate.Text + "# and Shift.SDate <=#" + tbEndDate.Text + "#");

Cheers

Carlakawill

  • 2 Contributors
  • 1 Reply
  • 70 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by ChrisPadgham
Member Avatar for ChrisPadgham

I am not a C# programmer but something like below adjusted if necessary for C#

WHERE Shift.SDate >=#" + format$(tbStartDate.Text,"mm/dd/yy") + "# and Shift.SDate <=#" + format$(tbEndDate.Text,"mm/dd/yy") + "#");

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.