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%'
SQL Command Not Returning Results in Calculated Field
SQL Command Not Returning Results in Calculated Field
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
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
Re: SQL Command Not Returning Results in Calculated Field
Ooops, I did it again and forgot to change the field type of the Calculated Field from INTEGER to VARCHAR
which solved the problem
which solved the problem
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
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