a0k0a7
asked on
SQL help to gather expression for Today() on a report
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Kelvin,
When I do that I get error, 'GETDATE' is not declared. It may be inaccessible due to its protection level.
When I do that I get error, 'GETDATE' is not declared. It may be inaccessible due to its protection level.
ASKER
If I use Date I get error, Date is a type and cannot be used as an expression.
When I used Now() it returned nothing...
When I used Now() it returned nothing...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you
Kelvin