Change the date formate

[#1]

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

[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.

[jonathandienst · Accepted 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')

[arasantorule]

Hi,

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

The Date Function

Thanks

[#5]

Thank you dienst that is working,

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