Not your Normal Date conversion

[rmorgan]

well it might be but not one I have done before

Date Scraped is in this format

Jan. 18, 2012

Need to convert it to dd-MM-yyyy to perform matching

[Anil_G (Anil Gorthi)]

@rmorgan

please try this

DateTime.ParseExact("Jan. 18, 2012","MMM. dd, yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

cheers

[Yoichi]

Hi,

How about the following expression?

CDate(yourString).ToString("dd-MM-yyyy")

Regards,

[mkankatala (Mahesh Kankatala)]

Hi @rmorgan

Input= "Jan. 18, 2012"
Output= DateTime.ParseExact(Input.Replace(".","").Replace(",",""),"MMM dd yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

Output as below,

Hope it helps!!

[rlgandu (Rajyalakshmi Gandu)]

@rmorgan

well it might be but not one I have done before

Date Scraped is in this format

Jan. 18, 2012

Need to convert it to dd-MM-yyyy to perform matching

@rmorgan

DateTime.ParseExact("Jan. 18, 2012", "MMM. dd, yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

[Nawazish_Ahmad]

Hi @rmorgan

Use Below Expression

DateTime.ParseExact(“Jan. 18, 2012”,“MMM. dd, yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MM-yyyy”)

Hope it will helps you
Cheers!!

[pravallikapaluri]

@rmorgan

well it might be but not one I have done before

Date Scraped is in this format

Jan. 18, 2012

Need to convert it to dd-MM-yyyy to perform matching

Hi @rmorgan

DateTime.ParseExact(originalDate, "MMM. dd, yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")