Need help in formating date column

[vikasshana]

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

[kaushiknsolanki · Accepted solution]

Try this.

Date(Floor(Load_Date),'DD/MM/YYYY') as Load_Date

Regards,

Kaushik Solanki

[settu_periasamy]

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

[vikasshana]

thanks for this, it is working fine now..!!!!