Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: Change the date formate

If the two fields are string values:

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

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

4 Replies
MVP
MVP

Re: Change the date formate

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.

MVP
MVP

Re: Change the date formate

If the two fields are string values:

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

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

arasantorule
Contributor III

Re: Change the date formate

Hi,

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

The Date Function

Thanks

Not applicable

Re: Change the date formate

Thank you dienst that is working,

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