DATE CONVERT QUARY

i’m taking date from excel which is DD/MM/YYYY and need to convert into DD.MM.YYYY
Please help on this
DateTime.ParseExact(documentdate,“MM/dd/yyyy hh:mm:ss”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

Hi @sayed.tabrez

Please try this,

strText your variable coming from Excel

DateTime.ParseExact(strtext,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")

Thanks

@sayed.tabrez

Check below for your reference

Reference

Hope this may help you

Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.