Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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.
If the two fields are string values:
Date(Date#(oldDate, 'dd/MMM/yyyy'), 'dd/MM/yyyy')
Time(Time#(oldTime, 'hh:mm:ss'), 'hh:mm')
Thank you dienst that is working,
and thanks to arasantorule for sharing that page it is very helpful