Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
24/05/2018 04:50 |
Expected out put in list box.
24/05/2018
But getting out put in list box.
24/05/2018 |
24/05/2018 |
24/05/2018 |
24/05/2018 |
24/05/2018 |
24/05/2018 |
24/05/2018 |
24/05/2018 |
24/05/2018 |
24/05/2018 |
Regards,
Vinod.
try date(floor(dateField))
Regards,
try date(floor(dateField))
Regards,
Hello can you provide scenario in qvw? because i am not able to reproduce the scenario in my test qvw.
Hi,
Try this
Date(Floor(Subfield([Contact Date and Time], ' ' , 1)),'DD/MM/YYYY')
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
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50
24/05/2018 04:50];