Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET
hello can any one solve my problem. my problem is:-
 
i m developing a code for inventory management in vb.net 2005 and use access database.
i used Format function for date formating as ;
 
textboxDate.Text=Format(Today.Date,"dd/MM/yyyy")
dim D1 as Date
D1=textboxDate.Text
 
"Select * From Table1 Where Tr_Date=#"+D1+"#"
 

it is working but when ever i changed the Date setting of my system it cant be working for all types when i use this date to compare date from database.
 
so plz help me to solve this problem.
thanks
Posted 8-Oct-10 10:07am
Edited 8-Oct-10 10:13am
v4

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I have also had date problems in the past when working with database or just raw data.
 
I now make a point of always using 3 char month when passing the date in queries.
 
e.g. 06/06/2010 = 06/Jun/2010
  Permalink  
Comments
ashishshingade at 25-Mar-11 23:58pm
   
Thank Bro

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 375
1 _Amy 235
2 Andreas Gieriet 180
3 Peter Leow 175
4 Dave Kreskowiak 155
0 OriginalGriff 7,540
1 Sergey Alexandrovich Kryukov 6,462
2 Maciej Los 3,849
3 Peter Leow 3,653
4 CHill60 2,712


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 8 Oct 2010
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100