Display formats

[Marvo]

Hi

I have a Time field in a Browse/Edit form. When I add a new record, the time field displays correctly and I can enter a time e.g. 13:00
And it loos fine in the Edit form

In the Browse form it displays as 13:00:00

I don't want to show the seconds so I edited the Browse form properties - Time column - Format and added my custom format: hh:nn

Now the Browse screen doesn't display the Time at all - just a null/blank field

Just confused how to get the time to display as hh:nn in the Browse form

Thanks for any help

[kev1n]

What data type is the time column in the database?

[Marvo]

What data type is the time column in the database?

in the database the column data type is 'time'

[kev1n]

Use TIME_FORMAT() to format the time.

[Marvo]

Thanks Kevin!

I added a %: in the middle to format correctly. I now understand the SQL time formats H, h, I, i.
I'm just curious about why the system doesn't use the format I created for the Edit form - hh:nn ?

It's working anyway - so thank you!

[kev1n]

Can you try this updated nuformclass.js ? Replace the existing one in the /core folder and log in again.

Update: This Patch is now included.