New Bug Encountered: Decimal value in virtual column in display mode

[Don_WF_Wong]

I have a virtual column which calculate age based on birthday.

In view mode the field doesn’t show decimal value, (it just shows 3.00) while in edit mode it show correctly, (3.17).

is it a bug?

[Don_WF_Wong]

hour(today() - [Applicant Birthday]) / 8760

I am using above formula.

[Aleksi · Accepted solution]

Instead of using 8760, use 8760.0

[Don_WF_Wong]

Thanks.
i works.

[Don_WF_Wong]

BTW, Is there any way to show the age in Year and Month, instead of decimal number?

[Steve]

No, you’ll have to calculate it.