Formatting different types of dates

[benmyers]

Hi,

I am scraping invoices and need to format the dates. Dates could be in any format such as below

28/10/20
28-10-20
2020-10-28
28.10.2021

etc…

I have tried the below assign code and many others just cant seem to find something that will work 100%

Assign: String was not recognized as a valid DateTime.

strparsedate = DateTime.ParseExact(dataSetResults.Tables(0).Rows(0).Item("InvoiceDate".ToString).ToString, “dd/MM/yyyy”,System.Globalization.DateTimeFormatInfo.InvariantInfo)

[Palaniyappan (Forum Leader)]

Hi

Did this thread help you resolve this

Problem with datetime.ParseExact()

Hello @Elya you can not pass String to DateTIme.Parse method. There can be work around but its all depends on you processing steps… we can give you DateTimeObject… but you may or may not need it… let us know why you want to parse string to datetime objects what will be your next processing steps etc.

Cheers @benmyers

[benmyers]

do you have an xaml of this. I keep getting errors

[lakshman (Ganta lakshman)]

@benmyers

May I know in what format you want to change the date ?

[benmyers]

yyyyMMdd

[lakshman (Ganta lakshman)]

@benmyers

Try this.

              CDate("yourDateTimeVar").ToString("yyyyMMdd")

[benmyers]

I had tried that but I didnt have the date set as date format in the taxonomy.

Its now working.

Thanks,

[ppr (Peter | MVP)]

Have a look here:

Compare two dates with different formats(string: "dd.MM.yyyy" and generic value "dd/MM/yyyy hh:mm:ss")

@silvia93 we can handle as following: see defined 2 test strings and a string array with the 2 different dateformats below: [grafik] Parsing we can do within an assign like this: DateTime.ParseExact(strDate1,Formats,CultureInfo.InvariantCulture,DateTimeStyles.None) DateTime.ParseExact(strDate2,Formats,CultureInfo.InvariantCulture,DateTimeStyles.None) And will receive following [grafik] the yellow lines are the statement that can be used within the condition block of an if Kindly note: …

DateTime.ParseExact(strDate1,Formats,CultureInfo.InvariantCulture,DateTimeStyles.None)

here we do handle different dateformats in one ParseExact

[benmyers]

I have tied this. Still getting the same error.

strparsedate = DateTime.ParseExact(dataSetResults.Tables(0).Rows(0).Item("InvoiceDate".ToString).ToString,dateformat,CultureInfo.InvariantCulture,DateTimeStyles.None)