Get Date Format?

[UiMe]

Hey, any idea how to read a string which represents Date (no matter what its format) and convert it to this format “dd.MM.yy”? Thanks

[PrankurJoshi]

Try this -

How to change the date format

hi as my date format is dd/mm/yyyy but while am pasting to excel file the format gets change to mm/dd/yyyy…can help me out with this.

Get a date in formart "dd/mm/yyyy"

How can I get a specific date format? In my case dd/mm/yyyy" I know that I could convet.toshortdatestring but I need that my variable will be a date not a string

[Sojan_Davis]

Before pasting to excel prefix “'”+DateTime.Now.ToString(“dd/MM/yyy”) which will paste the value as text