SYNTAX TO ADD DAYS TO THE DATE IN QUERY

[AMPVRAM]

i have to create a Maintenance Database schedule in Libre base , in this i have one requirement for query creation , when I enter the DONE ON DATE in the cell(column) the database must add the number of days specified in the INETRVAL DURATION and display the NEXT DUE DATE in the column.
the purpose is for scheduling the periodic maintenance of our machinery.

My database table Looks like this with the below field names

DONE ON DATE | INTERVAL DURATION | NEXT DUE DATE

please let me know what syntax should i use.

thank you …

[mgl]

Hello @AMPVRAM,

Have look at this post.

Kind regards, Michel

[igorlius]

Maybe this is helpful:
https://firebirdsql.org/refdocs/langrefupd21-intfunc-dateadd.html

[gkick]

HI,

In case you are using HSQLDB 2.+ as a backend, this syntax should do

TO_CHAR( DATEADD( ‘day’, [interval], [last] ), ‘DD/MM/YYYY’ ). This is how i work out a due date for an invoice by adding payment terms to the invoice date. The TO_CHAR in front of the dateaddd will ensure you end up with a date and not an integer.
Hope this helps