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 …