Query Question as Well

[rdrunner40]

Hi,

I have the following and just need to have the syntax for a query.

I have a date field with the date of a purchased item and i also want to show the total in Years and months that we have owned the article based on the current date.

where

for example date() - purchase date and then to format the ouput to be in years and months if possible.

so it would show 4yrs and 3 months ..... or something like that

Is this possible ?

regards

Roadrunner

 

[Golom]

Try this

DateDiff ("m", [Purchase Date], Date() ) \ 12 & " Years, " & 
DateDiff ("m", [Purchase Date], Date() ) Mod 12 & " Months"

 

[rdrunner40]

Hi,

I have pasted that it in and get a #error.....

I guess i am putting that all on one line ....

regards


roadrunner

 

[Golom]

Hard to diagnose. Can we see your complete query SQL?