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.
DATE(datekeyin,'DD-MM-YY') AS [Dates]
The correct way is to use the floor() function
Date(floor(DATE)) as Date
Retrieving data ...