Discussion board where members can get started with Qlik Sense.
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
Go to Solution.
If the two fields are string values:
Date(Date#(oldDate, 'dd/MMM/yyyy'), 'dd/MM/yyyy')
Time(Time#(oldTime, 'hh:mm:ss'), 'hh:mm')
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