Format date


#1

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 ??


#2

Hi @Finken,

Convert.ToDatetime(row(1).ToString).ToString(“dd.MM.yyyy”)
Use replace function ‘/’ to ‘.’

Regards,
Arivu


#3

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