How to convert date format

[erva (Mikko Erva)]

Hi,

I have date in format “2.1.2018” (d.m.yyyy). Need to get it in this format: “20180102” (yyyymmdd). How can it be done, days and months have to have leading zeros.

Thanks,

-mikko

[Mateus_Cruz]

First you read the date into a DateTime variable, as shown here:

How to change the format from .csv to .xls in automation

Or you can use like double dtvalue = double.Parse(row(Date)); DateTime dateInfo= DateTime.FromOADate(dtvalue)

Then you output to string in the format you want (“yyyyMMdd”) like this:

Change the formate of date

Hi, I need a date of the format mm.dd.yyyy and it should be 16 days less than current date.I am trying but the date is coming in the format mm/dd/yyyy along with time.

Details: Custom date and time format strings - .NET | Microsoft Learn

[erva (Mikko Erva)]

Ok, Thanks! I give it try.