Date format changing

[asiv.balan]

i have an invoice with invoice date format “yyyy/mm/dd” , but after extracting invoice date i need to write the data to excel in the format of “mm/dd/yyyy” , how can i do that??

[supermanPunch (Arpan)]

@asiv.balan You can try this Expression :
Datetime.ParseExact(yourDate,“yyyy/dd/MM”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)

[asiv.balan]

i am getting output in string variable

[supermanPunch (Arpan)]

@asiv.balan String Array ?

[asiv.balan]

sorry string variable

[supermanPunch (Arpan)]

@asiv.balan Yes you can convert it to a String datatype only if you need the format in that way