I have an issue with SQL which hopefully somebody might be able to help me with. I'm trying to find the date of an entry using the GETDATE Function. However, I'm receiving an error which is preventing me finding the date.
This error is "The GETDATE Function requires '0' arguments".
Here is the statement. Can anyone shed some light on where I'm perhaps going wrong? The 'date_entered' field is a date field by the way. Thanks in advance.
SELECT scheme.opheadm.order_no, scheme.opdetm.product GETDATE(scheme.opheadm.date_entered) AS Date
FROM scheme.opdetm INNER JOIN
scheme.opheadm ON scheme.opdetm.order_no = scheme.opheadm.order_no
WHERE (scheme.opheadm.customer = '3850692')
View Complete Post