Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Selection of date format

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.

1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Re: Selection of date format

Hi,

LOAD

    datekeyin,

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

Regards,

Sokkorn

2 Replies
Sokkorn
Honored Contributor

Re: Selection of date format

Hi,

LOAD

    datekeyin,

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

Regards,

Sokkorn

MVP & Luminary
MVP & Luminary

Re: Selection of date format

The correct way is to use the floor() function

Date(floor(DATE)) as Date

-Rob