Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've a date column and a Platform column in my app as below
Load_Date | Platform |
---|---|
23/11/2017 00:00:00 | A |
26/11/2017 01:27:55 | B |
26/11/2017 01:27:56 | B |
26/11/2017 01:27:57 | B |
26/11/2017 01:06:07 | C |
28/11/2017 06:39:24 | D |
I'm using the below formulae to convert into date format in Load script and I'm getting the below output
Date(Load_Date,'DD/MM/YYYY') as Load_Date .
Load_Date | Platform |
---|---|
23/11/2017 | A |
26/11/2017 | B |
26/11/2017 | B |
26/11/2017 | B |
26/11/2017 | C |
28/11/2017 | D |
But I would like to see something like below.
Load_Date | Platform |
---|---|
23/11/2017 | A |
26/11/2017 | B |
26/11/2017 | C |
28/11/2017 | D |
Regards,
Vikas
Try this.
Date(Floor(Load_Date),'DD/MM/YYYY') as Load_Date
Regards,
Kaushik Solanki
Try this.
Date(Floor(Load_Date),'DD/MM/YYYY') as Load_Date
Regards,
Kaushik Solanki
Try this..
LOAD date(floor(date#(Load_Date, 'DD/MM/YYYY hh:mm:ss'))) as Load_Date,
Platform
FROM
[https://community.qlik.com/thread/283231]
(html, codepage is 1252, embedded labels, table is @1);
thanks for this, it is working fine now..!!!!