Solved: Re: Help in date - Qlik Community

vinod22kv · ‎2018-05-26

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.

PrashantSangle · ‎2018-05-26

try date(floor(dateField))

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2018-05-26

try date(floor(dateField))

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

parthesh · ‎2018-05-26

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

sudhirpkuwar · ‎2018-05-26

Hi,

Try this

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

qlikviewwizard · ‎2018-05-26

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];

Help in date

Related Topics