DATE FORMAT vb.net issue

Question

0.00/5 (No votes)

See more:

hi everyone i have a question im using this code to get date

CDate(IIf(IsDate(dr("ApplicationDate").ToString), dr("ApplicationDate").ToString, "06/17/2013"))

yet im using this with a scenario i import .csv file then it will save also in my db which in this file there is no date inserted.. but it is already imported the date 06/17/2013 still viewed in my site im making my question is whta code that suits the code that im trying to update when uploading to update my date that 06/17/2013 will replace with a new date wherein i already update and insert in my database like this

insert (applicationdate) values (getdate())

thanks in advance

Posted 24-Jun-13 18:39pm

Member 10033107

Updated 24-Jun-13 18:42pm

Rajesh Anuhya

v2

Add a Solution

Comments

Jignesh Khant 25-Jun-13 1:15am

When you insert date using getdate() it inserts date in yyyy-MM-dd format and the one you are using is different, it will consider that format as string and hence will throw runtime error. So try using yyyy-MM-dd format.

Maciej Los 25-Jun-13 1:29am

What is dr?
How do you fetch the data?
You need to be more specific and provide more details...

1 solution

Add a Solution

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

chaau · Answer 1 · 2013-06-24T19:15:00

Solution 1

If I understood your question you need to use DateTime.Now[^] in place of "06/17/2013".

So, the code will be:

VB

CDate(IIf(IsDate(dr("ApplicationDate").ToString), dr("ApplicationDate").ToString, DateTime.Now.ToString))

Posted 24-Jun-13 19:15pm

chaau

Comments

Member 10033107 25-Jun-13 2:29am

Hi Andrew! your approach to my question is right to your understanding since i change datetime.now.tostring it gets an error so i change it as Today.TimeOfDay.ToString yet i got an error to quoted: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. it means it should be specific so how can i do that to fix this?

chaau 25-Jun-13 19:59pm

What happens if you use just Today.ToString?

Member 10033107 26-Jun-13 2:56am

hi Andrew.. i just use Today.Date and its fine working now thanks :)

DATE FORMAT vb.net issue

1 solution

Solution 1

Add your solution here

Preview 0

DATE FORMAT vb.net issue

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us