DATE DIFF BETWEEN SELECTED DATE & CURDATE()

The recommended method of customizing your AppGini-generated application is through hooks. But sometimes you might need to add functionality not accessible through hooks. You can discuss this here.
Post Reply
jrcervantest
Veteran Member
Posts: 32
Joined: 2020-06-22 00:00

DATE DIFF BETWEEN SELECTED DATE & CURDATE()

Post by jrcervantest » 2020-07-22 15:04

Request some assistance. I’m applying a calculated field to the last column (DTECALC) using the following statement to find the difference between two dates; a selected date and the current date.

SELECT DATE - CURDATE()
FROM LINKS
WHERE ID='%ID%’ 

The result seems to be working, except when it jumps to the next month the result is largely inaccurate. Does anyone know if we need to set the data type to particular value or am I missing an additional value in the SQL statement? Thank you for your assist. :D

V/r,
Attachments
Sample Form.jpg
Sample Form
Sample Form.jpg (71.94 KiB) Viewed 1600 times

jrcervantest
Veteran Member
Posts: 32
Joined: 2020-06-22 00:00

Re: DATE DIFF BETWEEN SELECTED DATE & CURDATE()

Post by jrcervantest » 2020-07-22 20:47

Found the answer for those that are interested!

SELECT DATEDIFF(date,curdate())
FROM links
WHERE id='%ID%'

nandrew
Posts: 5
Joined: 2019-10-16 12:24

Re: DATE DIFF BETWEEN SELECTED DATE & CURDATE()

Post by nandrew » 2021-02-10 19:27

Thanks a lot, It worked for me in a similar situation.

Post Reply