How to wirite previous date?

[vamsilver43 (Vamsilver)]

Hello There,

Hope you are doing well.

I have a question: Already there is a date present in the column, I just need to write that date to the previous date. How to read this current date and write the new date.

Kindly provide the solution ASAP.

Thanks
Vamsi

[Kamalen_Reddy (KamKam)]

Have you tried typing “yesterday” in an assign and using its properties?

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

Please use the below function. it would help.

Previous Day - Variablevaluefromtheexcel column.AddDays(-1).Tostring(“dd-MM-yyyy”)

REgards,
Kiran

[Srini84 (Srinivas Kadamati)]

@vamsilver43

Use Read Range activity to read the Excel and create a Variable in Output Datatable property

Use For Each Row activity to loop into Datatable

Use Assign activity to store the value as below

ExcelDate = row(“ColumnName”).ToString

Now Assign activity as below
ExcelPreviousDate = Convert.ToDateTime(ExcelDate).AddDays(-1).ToString(“Choose your format”)

Check below for your reference

How to Convert Date and Time Format using UiPath || RPA UseCase

Hope this helps you

Thanks