count the number of days

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Thank Karl that worke but there is a - infront of each day -10 -25 -30
how do i reove the - ?

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


Octet32 said:
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
Click to expand...
Click to expand...
 
try:

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



Vanderghast, Access MVP



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

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


Octet32 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Thanks thats it.

Michel Walsh said:
try:

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



Vanderghast, Access MVP



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

KARL DEWEY said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top