topic Re: Help in date in QlikView

Help in date

vinod22kv — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to extract the date from hte below field, All the records has the same date but when i am using the date function ilst box DUPLICATE has to remove and has to menction only single date since all has same date and diffternt time, but i am getting all the fileds with same data.

Contact Date and Time

24/05/2018 04:50

Expected out put in list box.

24/05/2018

But getting out put in list box.

24/05/2018

Regards,

Vinod.

Re: Help in date

PrashantSangle — Sat, 26 May 2018 10:34:46 GMT

try date(floor(dateField))

Regards,

Re: Help in date

parthesh — Sat, 26 May 2018 10:38:48 GMT

Hello can you provide scenario in qvw? because i am not able to reproduce the scenario in my test qvw.

Re: Help in date

sudhirpkuwar — Sat, 26 May 2018 10:54:19 GMT

Hi,

Try this

Date(Floor(Subfield([Contact Date and Time], ' ' , 1)),'DD/MM/YYYY')

Re: Help in date

qlikviewwizard — Sun, 27 May 2018 01:31:36 GMT

Hi,

Please check this.

Data:

LOAD date(Date#(DATE,'DD/MM/YYYY hh:ss'),'DD/MM/YYYY') as DATE inline [

DATE

24/05/2018 04:50

24/05/2018 04:50];