I am using a WeekEnd function in my load script to get a master calender at week level and the result I am getting is the date converted with respective weekend dates with the time stamp. I want the output without the time-stamp. I have tried converting the output format by using date and left function but they dont seem to work.
All the three examples below :
give same output as '12/2/2016 12:00:00 AM' (with the time stamp) when viewed in excel
is there an alternative for this in qlikview