Changing custom time to text in view

HCL Domino Domino Forum
1

Hi there,

I have a field in a form that uses date/time, custom, displays only time in 24 hour format. In the view, the time does not show the 24 hour format.

Example: In the form the field displays 18:00 and in the view it displays 06:00:00 PM.

I need to use this view for @dblookups, therefore I have formula @Text(STR_53;“S1”) - which converts to text.

Any help greatly appreciated.

2

Subject: Changing custom time to text in view

Leave the column as a date/time and use the formatting options on the formatting advanced tab (between the header style tab and the column data style tab). You need to change the column format option from “General” to “Date/Time”, then you get the same options as you do on the form field.

3

Subject: RE: Changing custom time to text in view

Thanks Stan!!! It worked!!! :slight_smile: