Member Avatar for vn412

Hi,
I am using vb.net 2010 with access 2007. everything works fine in XP, but when I switched over to windows 7 I did not proper result some queries
here is my query:

Select *  FROM tblname WHERE fordt=#13-12-2010#

.
It shows result in access as well as as in form.
I get value from form in MM/dd/yyyy format , but when it executes the query it automatically replaces it as system date-time format(dd-mm-yyyy)

Select *  FROM tblname WHERE fordt=#11-12-2010#

In windows 7 when i give date less than 12 e.g
it doesn't show any result in access as wellas as in form even there is record in table.

Please help as I have to submit project today.

Thanks

  • 2 Contributors
  • 1 Reply
  • 92 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by manoj_582033
Member Avatar for manoj_582033

Try This
dim d as datetime=now.date
Select * FROM tblname WHERE fordt=format("dd/mm/yy,d)

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.