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
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.
If the two fields are string values:
Date(Date#(oldDate, 'dd/MMM/yyyy'), 'dd/MM/yyyy')
Time(Time#(oldTime, 'hh:mm:ss'), 'hh:mm')
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
Retrieving data ...