Date format problem in vb.net

Question

0.00/5 (No votes)

See more:

when i am inserting date using vb in my access database showing wrong date

if my date is 01/04/2013 i.e. 1st April 2013 and when i am saving in database Access 2003 it shows me 04/01/2013 i.e. 04th Jan 2013 but this problem in XP only when i tried at my friend house it save perfect i.e. 1st April 2013 he uses windows 7.

Help me out of this

Frontend VB.net 2005 and backend Access 2003

in access datecolumn data type is date/time with short date formate
my code is

VB

"Insert into tablename(dateColumn) values('" & dtp.value & "')"  ' dtp.value= 01/04/2013

Posted 3-Apr-13 21:48pm

hareshdgr8

Updated 3-Apr-13 23:18pm

Maciej Los

v3

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2013-04-03T22:00:00

Solution 1

It is nothing to do with Access.
It is to do with the Culture settings on the PC. Look at the Control Panel, under (I think - it's been a while) International Settings and you will find that the PC using 4th Jan 2013 is set to US or similar MM/dd/yyyy, where the other is set to European dd/MM/yyyy

Posted 3-Apr-13 22:00pm

OriginalGriff

Comments

Maciej Los 4-Apr-13 4:20am

Yes, it does. Please, see my answer and read related links.

Kenneth Haugland · Answer 2 · 2013-04-03T22:01:00

Solution 2

Sounds like you just have a culture problem with the stored dates. The american way would write 1st April 04/01/2013 while most of the europeen writes 1/4/2013. But since I assume that you stored the value DateTime type in the database it shouldnt be a problem.

Posted 3-Apr-13 22:01pm

Kenneth Haugland

Comments

Maciej Los 4-Apr-13 4:21am

Yes, regional setting (culture) is a problem. See my answer and related links. DateTime data type field does not resolves problem ;(

hareshdgr8 4-Apr-13 4:33am

if i set datetime datatype in dateValue it also give me same problem in access database.

Rakesh Meel · Answer 3 · 2013-04-03T22:14:00

Solution 3

Thats No Issue
It is to do with the Culture settings on the PC. Look at the Control Panel,Regional Setting And Then Click On Date Option And Change The Date Format which is improper till Now

You Have to Change Short Date Format according to your Requirement dd/MM/yyyy

Posted 3-Apr-13 22:14pm

Rakesh Meel

Updated 3-Apr-13 22:23pm

v2

Comments

Maciej Los 4-Apr-13 4:23am

Changing regional settings does not guaratee 100% success.

hareshdgr8 4-Apr-13 4:40am

yes you are right then what i have to do sir.

hareshdgr8 4-Apr-13 5:11am

i did it but not solved what i did i am writing code for that whenever my application starts it change data format at dd/MM/yyyy after that same problem occur please tell me what should i do now

Maciej Los · Answer 4 · 2013-04-03T22:19:00

MS Access uses date format from system regional settings: short date format. To properly save date into MS Access database, you should set CultureInfo[^]. Than use DateTimeFormatInfo.FullDateTimePattern[^] to set date-string in correct format.

Tip:
The easiest way to avoid replacement between day<->month, is to use "en-US" date format ;)

More:
Globalization Namespace[^]
DateTimeFormatInfo[^]
10 tips for working with dates in MS Access[^]
MS Access tips: International Dates in Access[^]