nuBuilder Forum

When using the standard print button of the viewing form, the date in the format 2020-06-12 08:00:00 is displayed.
I would like to see this date in the format 12.06.2020 08:00

In the Form / Browse / Display field you need to define the format you want:
For example:
if your your field would be:

ofe_updated

replace it with:
the Format field should stay empty.

Janusz wrote:In the Form / Browse / Display field you need to define the format you want:
For example:
if your your field would be:

ofe_updated

replace it with:

Code: Select all

DATE_FORMAT(ofe_updated, "%d/%m/%Y %h:%i")

the Format field should stay empty.

Where is
"Form / Browse / Display field" ? Do I need to create it?

When you are on the form you want to modify press
CTRL+F
Next go to Browse Tab.

CTRL+SHIFT+F

Janusz wrote:CTRL+SHIFT+F

Thank !
It was necessary to explain what is being done in the field that needs to be formatted.

Janusz wrote:In the Form / Browse / Display field you need to define the format you want:
For example:
if your your field would be:

ofe_updated

replace it with:

Code: Select all

DATE_FORMAT(ofe_updated, "%d/%m/%Y %h:%i")

the Format field should stay empty.

Everything turned out, but the next problem appeared ... After I formatted the field for subform, it stopped working in the filter for the subform. I had to additionally enter the 'tab_data' field with width = 0 for subform, but now 2 fields with formatted and unformatted fields are printed from the main form. How to remove an unformatted field out of print?

With standard print procedure as far as I know you can not exclude specific fields. Maybe try to redefine the filter format to comply with new date format if possible.