Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have all these date formats and wanted to know how I can homogenize them to take only the day, month and year.
date
01031760 0924: 49
01032017 09:10
01032017 09:10:52 a
01032017 9:12 AM
01032017 9:16
03/03/2017 8:55:03
2017-03-01 09: 00: 09.0
01032017
010320170906
As you can see, all formats are very similar "DD / MM / YYYY", but there is one that puts the day, month and year "DD / MM / YY" and then add a 60 that I can not know what it is. This date is the one that is giving me the most problem because I do not know how to treat it.
If anyone can help me, thank you very much!
there is one that puts the day, month and year "DD / MM / YY" and then add a 60 that I can not know what it is.
Which one of the dates is adding 60?
date
01031760 0924: 49
01032017 09:10
01032017 09:10:52 a
01032017 9:12 AM
01032017 9:16
03/03/2017 8:55:03
2017-03-01 09: 00: 09.0
01032017
010320170906
Hi, thanks for your reply and your interest.
The date that adds a 60 is this: 01031760 0924: 49
As you can see, all dates are formatted DD / MM / YYYY, however the one with the number 60 format is DD / MM / YY. I need to pass that date to the same format as the others without having the account 60, because the year 1760 does not exist in my database.
Thank you very much for new, I hope you can help me.
I am not sure, Which one we need to follow -- Re: Different date formats in the same field
The format I want to get is DD / MM / YYYY. But the year 1760 does not exist in the database, the year 2017, the 60 I want to discard.
Thank you very much for the help
Does it always add a 60 when the format is DD/MM/YY?
Yes, he is the only record that does it. What I want is to convert it to the same format as the others: DD / MM / YYYY, regardless of the 60, since the actual year is 2017.
01031760 0924: 49 --> 01032017 (This format is the one I want)
Thank you very much!