If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I want to change the date formate from 20/Jul/2015 to 20/07/2015 in a loaded table
and time 22:39:00 to 22:39
If the two fields are string values:
Date(Date#(oldDate, 'dd/MMM/yyyy'), 'dd/MM/yyyy')
Time(Time#(oldTime, 'hh:mm:ss'), 'hh:mm')
View solution in original post
If the two fields are already proper QV numeric date time values:
Note this does not round the values to the nearest day or minute, it simply reformats them to not show the time for oldDate or the seconds in oldTime.
I believe the below post from 'heric' can help you.
The Date Function
Thank you dienst that is working,
and thanks to arasantorule for sharing that page it is very helpful