Date conversion Problem

Question

0.00/5 (No votes)

See more:

Hi All,
Happy New Year.

i have imported data from excel to Data set. it has date fields (Format:dd/MM/yyyy).

I am inserting Values in DB by converting Date Format to MM/dd/yyyy by using Globalization.

in Loop, First time date is converted from dd/MM/yyyy to MM/dd/yyyy .

but in next loop date field in data set it self in the format MM/dd/yyyy .

how can we resolve this?

Regards,
Pal

Posted 1-Jan-12 22:21pm

palraj001

Updated 1-Jan-12 22:23pm

Mehdi Gholam

v2

Add a Solution

Comments

Prasad_Kulkarni 2-Jan-12 4:23am

can u post the code,??

amit28august 2-Jan-12 4:30am

try to use Convert.ToDateTime('Ur_date_variable').ToString("dd-MMM-yyyy");
and then try to insert it.

sriman.ch 2-Jan-12 4:46am

Post your code so that we can Help you...?

RaviRanjanKr 2-Jan-12 14:41pm

without getting your effort its not easy for us to find out whats going wrong :)

2 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)

Tushar22Patel · Answer 1 · 2012-01-01T23:12:00

Solution 1

First you check if your excel sheet datacolumn is in format of datetime? and also check the format of it.
May be it is MM/dd/yyyy

Posted 1-Jan-12 23:12pm

Tushar22Patel

santhosh-padamatinti · Answer 2 · 2012-01-01T23:36:00

Solution 2

If you are sure that conversion requires only first time use some flag. By checking the flag status you can perform conversion operation.

Posted 1-Jan-12 23:36pm

santhosh-padamatinti