Dates error in QlikView using SQL Query

[stjernvd]

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 · Accepted solution]

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]

Hi Liron,

Thanks so much for this.

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

10 Sep 2015

?

[PrashantSangle]

Hi,

use

date(datefiled,'DD MMM YYYY')

  Regards