count the number of days

[Guest]

I need a query that will count the number of days an account is late I have a
column with the date, how do I count number of day from the date in column to
present in different column?

Thanks Octet

 

[Guest]

DateDiff("d", Date(), [YourDateField])

 

[Guest]

Thank Karl that worke but there is a - infront of each day -10 -25 -30
how do i reove the - ?

DateDiff("d", Date(), [YourDateField])
--
KARL DEWEY
Build a little - Test a little

I need a query that will count the number of days an account is late I have a
column with the date, how do I count number of day from the date in column to
present in different column?

Thanks Octet

 

[Michel Walsh]

try:

DateDiff("d", [YourDateField], Date() )



Vanderghast, Access MVP

Thank Karl that worke but there is a - infront of each
-10 -25 -30
how do i reove the - ?

DateDiff("d", Date(), [YourDateField])
--
KARL DEWEY
Build a little - Test a little

I need a query that will count the number of days an account is late I
have a
column with the date, how do I count number of day from the date in
column to
present in different column?

Thanks Octet

 

[Guest]

Thanks thats it.

try:

DateDiff("d", [YourDateField], Date() )



Vanderghast, Access MVP

Thank Karl that worke but there is a - infront of each
-10 -25 -30
how do i reove the - ?

DateDiff("d", Date(), [YourDateField])
--
KARL DEWEY
Build a little - Test a little


:

I need a query that will count the number of days an account is late I
have a
column with the date, how do I count number of day from the date in
column to
present in different column?

Thanks Octet