What is the challenge that you are facing?
my csv file have good date format but when i copy the file in excel the format change (I need to copy it in excel because i have a template with formulas)
How are you copying it in excel (which activity)?
yes with write range activity
It is actually showing date in improper format for rows which have date less than equal to 12 (dd)
Ok so how can i fix that ?
can you right click on csv file and open it in notepad to see the format of date.
change the extension of emp.txt file to .csv
The missing activity is excel application scope in which I am using write range to write the outDT to an excel file.
I don’t really understand your method
Did you run the workflow and saw the output?
It still txt file
First uncheck this check box
This PC → View ->Options->Change Folder and Search Options
i don’t have the same view where i need to click first ?
First Click on This PC (the icon may be present on your desktop)
Change Folder And Search Options
This is the result after running the workflow?
After running the workflow I got the following result
yes i used what you sent me