LO Base 4.0.3.3: DATEADD "Access is Denied" [closed]

asked 2013-06-15 10:22:26 +0200

Dycius gravatar image

updated 2015-10-04 19:18:53 +0200

Alex Kemp gravatar image

Hi all,

I'm trying to use the DATEADD funtion in some queries, but I keep getting this error message: image DATEADD 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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 19:19:02.634134