By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,935 Members | 1,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,935 IT Pros & Developers. It's quick & easy.

how to select date

P: 2
dear
I am working with vb project but facing difficulty in getting Records = 0 if date 01/11/2014 when I check database found 2 records see foolowing code

Mdate =Formaat(rs3!shedual,"dd/mm/yyyy")
rs.close
rs.open"select * from shedual where EffeDate=#" & Mdate & "#"
thank you
Dec 31 '14 #1
Share this Question
Share on Google+
1 Reply


twinnyfo
Expert Mod 2.5K+
P: 3,487
aziz sonnari,

First, it is most helpful to us if you copy and paste your code directly from your VB project, as it is clear that your code would from a formatting perspective. Also, please use the Code Tags when posting code.

Second, because you've only posted a very short snippet of your code, we don't know what rs3 is referring to. Then you close a different recordset (we can only assume) and then reopen it again. It is difficult to decipher what you are trying to do from the code supplied. Additionally, it does not look like you are actually searching for the date 1/11/2014, but only the value found in rs3!shedual.

If you provide us a few more details and explanation we will be glad to assist you.
Jan 2 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.