LO Base 4.0.3.3: DATEADD "Access is Denied"

[Dycius]

Hi all,

I’m trying to use the DATEADD funtion in some queries, but I keep getting this error message:

So, I created a very small query just to test this. The ActualStartDate field is of type date.

SELECT 
  "PK_FW_ID", 
  "FK_FW_S_Num", 
  "ActualStartDate", 
  DATEADD( 'd', 1, "ActualStartDate" ) AS "NextDay" 
FROM 
  "FiscalWeek" 
ORDER BY 
  "FK_FW_S_Num" ASC, 
  "ActualStartDate" DESC

How do I make DateAdd to work right?

Thanks,
Jon