Topic:   . i need to insert the date which is coming from csv file to the database my problem is the date is in formate 'yyyymmdd' i tried parsing it DateTime.ParseExact(dCRecord[7],
Dec 19, 2020 14:11 2 Replies 815 Views SHIVA

. i need to insert the date which is coming from csv file to the database my problem is the date is in formate 'yyyymmdd' i tried parsing it DateTime.ParseExact(dCRecord[7], "yyyyMMdd", CultureInfo.InvariantCulture) like this but it is not picking up the date?

Prev Next
Topic Replies (2)
  1. 1
    idnkx user

    PARTH

    In yyyymmdd , mm stands for minutes while in yyyyMMdd, MM stands for months. That is the difference, that is why you are getting error. Make both the formats same -> yyyyMMdd

    1
    idnkx user

    FRAUSKY

    Open your file in Excel AND check the data.

Leave a Reply
Guest User

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.


Let`s Connect