hi all ,
I have a field like "opened time" -> it's showing like this "'1.22:43:8.000'' s but my requirement need to display into MM:SS format can anyone help me soon
Use the time() function: Time([opened time],'hh:mm:ss')
What is the format of the opened time field
You can try with
Time( [opened time],'hh:mm')
Retrieving data ...