Error to write in a date field in excel

excel
activities

#1

Hello! i have a problems at the moment to write an date value in excel because it looks that the data is changed.

For example, I need to write the date starting with the day following for the month and year, the value is
04/06/208 but in excel is written 06/04/2018.

How can I solve this problem?

This is the value as I want it will be written

image

This is the value wrote

image


#2

@Lucky0906 change format of date your writing in to excel into Excel format.


#3

Try this @Lucky0906 and let us know, DateTime.ParseExact(StrFecha_Dia.tostring,
“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)


#4

I solved the issue adding ’ before the variable in order to write the data as string and not as date

“’”+Date_Start