Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

vikasshana
New Contributor III

Need help in formating date column

 

Hi,

 

I've a date column and a Platform column in my app as below

 

Load_DatePlatform
23/11/2017  00:00:00A
26/11/2017  01:27:55B
26/11/2017  01:27:56B
26/11/2017  01:27:57B
26/11/2017  01:06:07C
28/11/2017  06:39:24D

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_DatePlatform
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_DatePlatform
23/11/2017  A
26/11/2017  B
26/11/2017  C
28/11/2017  D

Regards,

Vikas

Tags (1)
1 Solution

Accepted Solutions

Re: Need help in formating date column

Try this.

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


Regards,

Kaushik Solanki

3 Replies

Re: Need help in formating date column

Try this.

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


Regards,

Kaushik Solanki

Re: Need help in formating date column

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
New Contributor III

Re: Need help in formating date column

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