SQL Command Not Returning Results in Calculated Field

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
mohamed
Veteran Member
Posts: 80
Joined: 2020-04-19 16:18

SQL Command Not Returning Results in Calculated Field

Post by mohamed » 2021-08-28 15:46

Hello,

I am running successfully to run the following SELECT command to calculate the days and hours by calculating the difference between to DateTime fields using PHPmyadmin BUT when I use the same on AppGini it does not return any result!!!

What am I missing ?



SELECT
Start_DateTime, End_DateTime,
CONCAT(
TIMESTAMPDIFF(Day, Start_DateTime, End_DateTime),'d ',
LPAD(MOD(TIMESTAMPDIFF(Hour, Start_DateTime, End_DateTime), 24), 2, '0'), 'h'
)
AS DaysHours
FROM DailyTasks
WHERE DailyTasks.id = '%ID%'
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course

mohamed
Veteran Member
Posts: 80
Joined: 2020-04-19 16:18

Re: SQL Command Not Returning Results in Calculated Field

Post by mohamed » 2021-08-28 16:03

Ooops, I did it again and forgot to change the field type of the Calculated Field from INTEGER to VARCHAR :idea:
which solved the problem :roll:
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course

Post Reply