Dates....

[ukgthor]

I have a date field formatted as dd/mm/yyyy which denotes the date that the product was last received into the business. I want to use this field to complete some analysis on the age of the stock to give me the following results:

0 - 3 Months
3 - 6 Months
6 - 9 Months
9 - 12 Months
12 - 18 Months
18 - 24 Months
>24 Months

Is there a formula that I can use to count the number of months (or weeks if easier) from the date field mentioned above to the date the query is run ?.

Thanks in advance.

 

[pbaldy]

Check out the DateDiff() function and the Date() function.

 

[raskew]

And to add to Paul's response:

Check out the "Q" (quarters) option to the DateDiff() function.

Best wishes - Bob