Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change the date formate

Hi,

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

Thanks,

Mani

1 Solution

Accepted Solutions
jonathandienst

If the two fields are string values:

Date(Date#(oldDate, 'dd/MMM/yyyy'), 'dd/MM/yyyy')

Time(Time#(oldTime, 'hh:mm:ss'), 'hh:mm')

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
jonathandienst

If the two fields are already proper QV numeric date time values:

Date(oldDate, 'dd/MM/yyyy')

Time(oldTime, 'hh:mm')

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst

If the two fields are string values:

Date(Date#(oldDate, 'dd/MMM/yyyy'), 'dd/MM/yyyy')

Time(Time#(oldTime, 'hh:mm:ss'), 'hh:mm')

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

arasantorule
Creator III
Creator III

Hi,

I believe the below post from 'heric' can help you.

The Date Function

Thanks

Not applicable
Author

Thank you dienst that is working,

and thanks to arasantorule for sharing that page it is very helpful