Date format changing in excel sheet

Hello everyone
I’m using this activity
image
and i’m getting this as a result
image
I need the format : dd/mm/yyyy

Hi @dhouha.cherif ,

Could you try changing the value to the below and Check if it works :

"'"+DateTime.Now.ToString("dd-MM-yyyy")

@dhouha.cherif

you have two options

one which is mentioned above to add a literal at start which converts it to string type and will display as is but you have to change format to dd/MM/yyyy in your code

two …use format cell activity and format your excel cell to the required format …if it is a template on the template use the format directly, then you dont need format cell activity as well

Hope this helps

cheers

1 Like

Like a charm
Thank you very much

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.