How can I get a date in this format: 27.01.2017
I try this: CDate(row(1).ToString).ToString(“dd.MM.yyyy”)
But that give me the date in this format 27/01/2017
I want the dot as a delimiter ??
1 Like
Hi @Finken,
Convert.ToDatetime(row(1).ToString).ToString(“dd.MM.yyyy”)
Use replace function ‘/’ to ‘.’
Regards,
Arivu
Hi there @Finken,
What you’ve described should work.
For example, the following works for me:
Assign - strDateTest = "27/01/2018"
Log - DateTime.Parse(strDateTest, New System.Globalization.CultureInfo("en-gb")).ToString("dd.MM.yyyy")
Returns:
27.01.2018
Thanks,
Josh