topic Re: Different date formats in the same field in QlikView

Different date formats in the same field

Anonymous — Mon, 10 Apr 2017 07:51:52 GMT

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!

Re: Different date formats in the same field

sunny_talwar — Mon, 10 Apr 2017 08:58:24 GMT

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

Re: Different date formats in the same field

Anonymous — Mon, 10 Apr 2017 09:32:21 GMT

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.

Re: Different date formats in the same field

Anil_Babu_Samineni — Mon, 10 Apr 2017 09:50:28 GMT

I am not sure, Which one we need to follow -- Re: Different date formats in the same field

Re: Different date formats in the same field

Anonymous — Mon, 10 Apr 2017 10:01:47 GMT

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

Re: Different date formats in the same field

sunny_talwar — Mon, 10 Apr 2017 10:51:16 GMT

Does it always add a 60 when the format is DD/MM/YY?

Re: Different date formats in the same field

Anonymous — Mon, 10 Apr 2017 12:29:10 GMT

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!