topic Need help in formating date column in QlikView

Need help in formating date column

vikasshana — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Need help in formating date column

kaushiknsolanki — Tue, 28 Nov 2017 11:01:34 GMT

Try this.

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

Regards,

Kaushik Solanki

Re: Need help in formating date column

settu_periasamy — Tue, 28 Nov 2017 11:01:44 GMT

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

Re: Need help in formating date column

vikasshana — Tue, 28 Nov 2017 11:15:17 GMT

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