Selection of date format

[#1]

Hi All,

I am extracting data with current format is datetime.

How would i change the date format as i only want to capture date only and discard the time in qlikview loading phase.

eg:

LOAD

    datekeyin,

Thanks.

[Sokkorn · Accepted solution]

Hi,

LOAD

    datekeyin,

     DATE(datekeyin,'DD-MM-YY')     AS [Dates]

Regards,

Sokkorn

[rwunderlich]

The correct way is to use the floor() function

Date(floor(DATE)) as Date

-Rob