G
Golfinray
I have datediff commands in two queries and I am storing the differences in
tables. I am using datediff("d",[date plans received],[date plan review
letter sent]) in both queries. I am getting some squirelly answers. On one
set of dates, it works fine. One will be 6/12/2007 and the other 6/19/2007
and it will return the answer I'm looking for, 7. On another it will will
return 385 days which can't be right. By the way, my data type in the table
where the number is stored is number. All the data types on the dates are
date/time. What am I doing wrong? Thanks so much!!!
tables. I am using datediff("d",[date plans received],[date plan review
letter sent]) in both queries. I am getting some squirelly answers. On one
set of dates, it works fine. One will be 6/12/2007 and the other 6/19/2007
and it will return the answer I'm looking for, 7. On another it will will
return 385 days which can't be right. By the way, my data type in the table
where the number is stored is number. All the data types on the dates are
date/time. What am I doing wrong? Thanks so much!!!