I need a DATE_ADD function or alternative for calculating dates in Base. I have tried DATE_ADD(StartDate,INTERVAL). I have tried the syntax many different ways, normally I get SQL errors saying its expecting a BETWEEN or IN.
If I try DATE_ADD(StartDate, ‘y’) instead of errors I get "The data content could not be loaded… Access is denied DATE_ADD in statement…)
All I want to do is generate a query that will tell me when things are coming due again so I can do a report monthly, weekly, yearly, etc where it will calculate what is due based on its start date or last complete date.
Is there any way to do this in base using SQL, or even in the report builder? Any suggestions would be greatly appreciated. Thanks!