Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master
Master

Hi,

LOAD

    datekeyin,

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

Regards,

Sokkorn

View solution in original post

2 Replies
Sokkorn
Master
Master

Hi,

LOAD

    datekeyin,

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

Regards,

Sokkorn

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The correct way is to use the floor() function

Date(floor(DATE)) as Date

-Rob