How to enter date in same format to Excel

[mavsp8 (mavs)]

I have Created a DateTable which contains column Start_Date and its DataType is String.

I have used Assign Activity and Created a Variable named it as Start_Date and
DataType is String and Value is “2020-04-01 00:00:00”

When I use Write DataTable to Excel Activity it enters date into excel with different format:

I want Date to be inserted in following format:

“yyyy-mm-dd hh:mm:ss”

Need help to solve this issue, highly appreciate any help.

[RajKumar_DC (RajKumar Durai)]

Hi @mavsp8,

Hope you convert and write it like below

if possible share your workflow

Thanks,

[Anil_G (Anil Gorthi)]

@mavsp8

You have to modify the excel cell formatting if you need to view that way…format cell is the activity

Cheers

[Sanjit_Pal]

Hey @mavsp8,

It is the excel functionality, so better if you add apostrophes (‘) before the date string and then write to excel it will solve your issue.

For better understanding you can go through Stop automatically changing numbers to dates - Microsoft Support

Thanks,
Sanjit