No se puede reconocer la cadena como valor DateTime válido

Question

Buen día.

Tengo una aplicación web, desplegada en el IIS de un servidor que está en la nube.

Constantemente me sale un error de manera intermitente que indica "No se puede reconocer la cadena como valor DateTime válido" , luego de un rato la data se vuelve a consultar, y funciona bien, después nuevamente sale el error, y así consecutivamente.

Lo cual no es correcto, ya que trae mucho retraso en el ambiente productivo. Cabe recalcar que anteriormente tenían un servidor físico, y funcionaba muy bien. Ahora el error se presenta desde que pasaron al servidor en nube, sin haber hecho ningún cambio.

Ejemplo :

string fecha = "05/09/2024"; // formato dd/MM/aaaa

DateTime fechaD = Convert.ToDateTime(fecha);

Error : No se puede reconocer la cadena como valor DateTime válido

Su apoyo por favor, es urgente

Answer 1

Hi @Palma Quintanila,Martha Jenniffer Alexandra

This is a forum using English, please edited your post for better support.

Regarding your issue, what is the code like?

Sometimes the syntax is different between the physical server and cloud server.

Best regards,

Cosmog

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Your code is making an assumption that isn't necessarily true. Most likely while you had your software running on a physical server then you had control over the locale and therefore the formatting of date/time values. However once you moved to the cloud that is no longer true. Although if you're running a VM in the cloud then you can control the locale information. If you're hosting your app using Azure App Services then you need to set the locale in your web.config file. This should solve your initial problem.

I'm going to guess you periodically see failures when you see dates where the middle value is > 12 since your formatting is assuming it is month but by default it is most likely day hence 05/12 is 12 May, not 5 Dec. To properly fix this ideally you should explicitly specify the formatting to use. This eliminates any issues with OS locale. If you have a web app that needs to manage this for the user then ensure you are setting the locale information for the app instead.

To ensure strings are parsed properly you should do something like this.

DateTime fechaD = DateTime.ParseExact(fecha, "dd/MM/yyyy", null);

When parsing strings it is preferable to use DateTime.Parse or DateTime.ParseExact. If you absolutely must use Convert.ToDateTime then note that there is no version that allows you to specify the format that is expected. Instead you'll need to either ensure the thread's CultureInfo is properly set or get the correct IFormatProvider for the locale you want to use and pass it in.

IFormatProvider provider = new CultureInfo("en-US");
DateTIme fechaD = Convert.ToDateTime(fecha, provider);