Date Diff

  • Thread starter Thread starter lmossolle
  • Start date Start date
L

lmossolle

I am using office 2007 and in need of help to find the age of item. Could
someone please assist?

I have a table named table, I have a Date_Rec ands would like to determine
what the age was if Complete = No.

Thanks!!!!
 
I am using office 2007 and in need of help to find the age of item. Could
someone please assist?

I have a table named table, I have a Date_Rec ands would like to determine
what the age was if Complete = No.

Thanks!!!!
Click to expand...

Age in... years? days? Seconds? What do you want to see if Complete is Yes?

You'll want to use the DateDiff() function but you'll need to post more
details.
 
In Days, sorry for the delay!!!!

John W. Vinson said:
Age in... years? days? Seconds? What do you want to see if Complete is Yes?

You'll want to use the DateDiff() function but you'll need to post more
details.
Click to expand...
 
If complete = No

John W. Vinson said:
Age in... years? days? Seconds? What do you want to see if Complete is Yes?

You'll want to use the DateDiff() function but you'll need to post more
details.
Click to expand...
 
If complete = No
Click to expand...

Imossole, it's a bit hard to answer a question consistiong of "If complete =
no". We cannot see your screen, we don't know your table structure, etc.

I'm GUESSING that you want a Query based on some (unspecified, you didn't say)
table, with a criterion of No on the Complete field (make it "No" if that's a
text field rather than a yes/no field); in a vacant field cell in the query
type

Age: DateDiff("d", [Date_Rec], Date())
 
Got it to work

Used in my query design veiw the following:

Age: DateDiff("yyyy",[Birthdate],Date())

Thanks for the help - the link helped me to realize what I was doing wrong

Have a great day!

John W. Vinson said:
If complete = No
Click to expand...

Imossole, it's a bit hard to answer a question consistiong of "If complete =
no". We cannot see your screen, we don't know your table structure, etc.

I'm GUESSING that you want a Query based on some (unspecified, you didn't say)
table, with a criterion of No on the Complete field (make it "No" if that's a
text field rather than a yes/no field); in a vacant field cell in the query
type

Age: DateDiff("d", [Date_Rec], Date())
Click to expand...
 
Back
Top