Date format change in excel

[Gokul_Murali]

I have excel column having format like this

IAM performing this activity

after this iam using a write range activity but the format got changed to below

Is there any possible way to avoid this

[mkankatala (Mahesh Kankatala)]

Hi @Gokul_Murali

You are converting the approval date to the string format in the assign activity that’s why it was changing the format in the excel.

Instead of that convert the LastDate variable to the DateTime datatype and give the expression in assign activity,

- Assign -> LastDate = AppDate.addmonths(2)

Then try.

Hope it helps!!

[Gokul_Murali]

But here if the date in approval column is in january,feb, march i want to get the march last date

and if the date column in approval coumn is April, May, June i want to get the june last date

How can i get that

LastDate = AppDate.addmonths(2) = when i use this iam getting the same value