topic Re: Dates error in QlikView using SQL Query in QlikView

Dates error in QlikView using SQL Query

stjernvd — Fri, 18 Sep 2015 08:34:08 GMT

Hi,

When I create this table,

Dates:

LOAD
Concat(Chr(39) & date& Chr(39), ', ' ) As date;
SQL SELECT
date
FROM xxx;

Let vChoose = peek('date', 0, 'Dates');

I get the following values:

'42226', '42227', and so on.

I should be getting:

'20/07/2015 00:00:00' in this format.

What am I doing wrong?

lironbaram — Fri, 18 Sep 2015 08:37:26 GMT

you can change the script to

Dates:

LOAD
Concat(Chr(39) & date(dt_bus,'DD/MM/YYYY')& Chr(39), ', ' ) As date;
SQL SELECT
dt_bus
FROM TOOLS_DATA_HIST;

Let vChoose = peek('date', 0, 'Dates');

stjernvd — Fri, 18 Sep 2015 09:06:10 GMT

Hi Liron,

Thanks so much for this.

How would I get the date into this format, for example:

10 Sep 2015

PrashantSangle — Fri, 18 Sep 2015 09:13:14 GMT

Hi,

use

date(datefiled,'DD MMM YYYY')

Regards