Access Query - DateTime

[Fritz Switzer]

I have a DateTime field in my Access table named AuditTime.

I'm having trouble creating a SQL query that will return all records that
are "older" than 12 hours. I've tried different variations of the
following:

SELECT *
FROM Charts
WHERE (DATEDIFF('hh', [ AuditTime], NOW()) = '12')

"No value given for one or more parameters" is the error message.

TIA,

Fritz

 

[Rick Brandt]

I have a DateTime field in my Access table named AuditTime.

I'm having trouble creating a SQL query that will return all records
that are "older" than 12 hours. I've tried different variations of
the following:

SELECT *
FROM Charts
WHERE (DATEDIFF('hh', [ AuditTime], NOW()) = '12')

"No value given for one or more parameters" is the error message.

SELECT *
FROM Charts
WHERE DATEDIFF('hh', [AuditTime], NOW()) > 12)

DateDiff return an integer so no quotes. Plus "=" would only return records
that are exactly 12 hours old.

 

[Rick Brandt]

SELECT *
FROM Charts
WHERE DATEDIFF('hh', [AuditTime], NOW()) > 12)

DateDiff return an integer so no quotes. Plus "=" would only return
records that are exactly 12 hours old.

Also "hh" should be "h".

 

[Fritz Switzer]

Rick,

thanks for the quick response. but I'm getting an Invalid Procedure Call
with



Plus there was an extra paren.

SELECT *
FROM Charts
WHERE DATEDIFF('hh', [AuditTime], NOW()) > 12)

Any additional ideas,

Fritz

I have a DateTime field in my Access table named AuditTime.

I'm having trouble creating a SQL query that will return all records
that are "older" than 12 hours. I've tried different variations of
the following:

SELECT *
FROM Charts
WHERE (DATEDIFF('hh', [ AuditTime], NOW()) = '12')

"No value given for one or more parameters" is the error message.

SELECT *
FROM Charts
WHERE DATEDIFF('hh', [AuditTime], NOW()) > 12)

DateDiff return an integer so no quotes. Plus "=" would only return
records that are exactly 12 hours old.

 

[Rick Brandt]

Rick,

thanks for the quick response. but I'm getting an Invalid Procedure
Call with



Plus there was an extra paren.

SELECT *
FROM Charts
WHERE DATEDIFF('hh', [AuditTime], NOW()) > 12)

Any additional ideas,

See my previous message. 'hh' needs to be 'h'.

 

[Fritz Switzer]

Bingo !!!

Thanks Rick Happy Thanksgiving

Rick,

thanks for the quick response. but I'm getting an Invalid Procedure
Call with



Plus there was an extra paren.

SELECT *
FROM Charts
WHERE DATEDIFF('hh', [AuditTime], NOW()) > 12)

Any additional ideas,

See my previous message. 'hh' needs to be 'h'.