Discussion board where members can get started with QlikView.
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.
Go to Solution.
DATE(datekeyin,'DD-MM-YY') AS [Dates]
The correct way is to use the floor() function
Date(floor(DATE)) as Date