Date format mm/dd/yyyy to dd/mm/yyyy

[jues]

Greetings friends

I am working with a Dates form (fmrfechas) that contains three Text Boxes Date of Birth (TxtNACIMIENTO), Date of Admission (TxtINGRESO) and Date of Accident (TxtACCIDENTE) whose information is reflected in cells D16, G16, I16 on Sheet8 (HOME) However, I transcribe the information in the dd/mm/yyyy format but it is reflected in the mm/dd/yyyy format, which results in errors in the results obtained from the decomposition or combination of said dates.

Specifically, I require help with the necessary lines of code so that the information is reflected in the dd/mm/yyyy format and I can use it in combination with other formulas within the spreadsheet.

I will be very grateful for the help you can give me.

 

[Coyotex3]

Would using the text formula work in this case?

In my example, I have the date listed as 12/31/2023. But if I wanted it to show up as 31/12/2023 I would just use the Text formula and then write the desire format such as below.

=TEXT(A1,"dd/mm/yyyy")

You can also go to custom format and change the date type to the one desired.

 

[jues]

Saludos amigo, agradezco tu apoyo, pero el sistema no funciona, sigue tomando los datos en formato mm/dd/aaaa a pesar de haber hecho todo lo que me dijiste =(

 

[Coyotex3]

Would it be possible for you to post an example of what your data looks like and the expected results? Just a small sample without any personal information.

P.S. if you need help in Spanish. Please post in the questions in other language section. This section only allows English per the rules.( Amigo, si necesitas ayudas en Español, por favor escribe en la otra sección. Por las reglas del Forum).

 

[Peter_SSs]

Saludos amigo, agradezco tu apoyo, pero el sistema no funciona, sigue tomando los datos en formato mm/dd/aaaa a pesar de haber hecho todo lo que me dijiste =(

@jues
In future, as noted on the main forum page, please post in English only in this forum.

 

[jues]

Would it be possible for you to post an example of what your data looks like and the expected results? Just a small sample without any personal information.

P.S. if you need help in Spanish. Please post in the questions in other language section. This section only allows English per the rules.( Amigo, si necesitas ayudas en Español, por favor escribe en la otra sección. Por las reglas del Forum).

Excuse me my friend about the language, the automatic translator usually plays some jokes, I was able to solve the problem with this code

Me.TxtNACIMIENTO.Value = Format(Me.TxtNACIMIENTO.Value, "dd/mm/yyyy")
Range("D16").Value = Me.TxtNACIMIENTO
Me.TxtINGRESO.Value = Format(Me.TxtINGRESO.Value, "dd/mm/yyyy")
Range("G16").Value = Me.TxtINGRESO
Me.TxtACCIDENTE.Value = Format(Me.TxtACCIDENTE.Value, "dd/mm/yyyy")
Range("I16").Value = Me.TxtACCIDENTE