SQL Query Date Related SELECT Statement

Question

This is my query which runs perfectly

"SELECT RemBal FROM Sales WHERE CustomerName='" & CustomerName.Text & "'"

now i am trying to get the balance on two basis customer name & current date

"SELECT RemBal FROM Sales WHERE CustomerName='" & CustomerName.Text & "' AND SaleDate=#" & SaleDate.Value & "#"

now this query not giving me any error but not returning any value too please help

if u are asking about date format then 02-01-2014 its a date picker — xsheru
– xsheru, Commented Jan 2, 2014 at 5:10
Try putting the date in a format of yyyy-mm-dd. I have had success with this access using this format in the past — Kane
– Kane, Commented Jan 2, 2014 at 5:10
if i use '" & & "' its giving me error... data type mismatch — xsheru
– xsheru, Commented Jan 2, 2014 at 5:12
using yyyy-mm-dd did solved the problem... MS-ACCESS database always needs some odd things — xsheru
– xsheru, Commented Jan 2, 2014 at 5:16

Vignesh Kumar A · Accepted Answer · 2014-01-02 05:19:30Z

1

Try this

SaleDate.Format = DateTimePickerFormat.Custom
SaleDate.CustomFormat = "yyyy-mm-dd"

"SELECT RemBal FROM Sales WHERE CustomerName='" & CustomerName.Text & "' AND SaleDate=#" & SaleDate.Text()  &"# "

answered Jan 2, 2014 at 5:19

Vignesh Kumar A

28.6k14 gold badges67 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hawk · Accepted Answer · 2014-01-02 08:29:01Z

0

SELECT rembal 
FROM   sales 
WHERE  customername = '" & CustomerName.Text & "' 
       AND Format(saledate, 'dd/MM/yyyy') = '" & SaleDate.Value & "'

edited Jan 2, 2014 at 8:29

Hawk

5,17014 gold badges55 silver badges78 bronze badges

answered Jan 2, 2014 at 5:25

senthilkumar2185

2,5983 gold badges23 silver badges38 bronze badges

Collectives™ on Stack Overflow

SQL Query Date Related SELECT Statement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related