Calculated field error logs

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
SkayyHH
Veteran Member
Posts: 425
Joined: 2015-04-27 21:18

Calculated field error logs

Post by SkayyHH » 2022-01-19 17:03

Hi,

i have a calculated field with this query:

Code: Select all

select TIMESTAMPDIFF(year,date_of_birth,NOW()) as age from employees_de where id=%ID% 
The fields in the table "employees_de" are:

"date_of_birth" as Data Type: Date
"age" as Data Type: Integer

The calculation works.

But in query logs i get that errors:

Page: /ajax-update-calculated-fields.php

UPDATE `employees_de` SET `age`='' WHERE `ID`='1'
Incorrect integer value: '' for column `app`.`employees_de`.`age` at row 1

Can someone please help me what is the problem?

Thank you very much!

Post Reply