CREATE FUNCTION weekdays (DATE1 DATETIME, DATE2 DATETIME)
RETURNS INTEGER
BEGIN
RETURN DATEDIFF(day, DATE1, DATE2);
END
ERROR: syntax error at or near "BEGIN" LINE 3: BEGIN
What am I missing. I've tried a number of variations but nothing has solved it yet. I'm using MySQL.
Try this:
delimiter $$
CREATE FUNCTION weekdays (DATE1 DATETIME, DATE2 DATETIME)
RETURNS INTEGER
BEGIN
RETURN DATEDIFF(DATE1, DATE2);
END $$
DATEDIFF take only two params.
How it worked for me:
SELECT A.DOCNUMBR,A.DOCDATE,DATEDIFF(DAY,A.DOCDATE,GETDATE()) AS DAYS_CALC,
FROM RM_TRANSACTIONS AS A
WHERE A.CURTRXAMNT <> 0
The result presents the Document Number, the Document Date and the age of the Document in number of days.
This is very useful if you want to eventually create an Aging Report later in Excel.
Erwin-PR
