Calculate Quarters based on today

[iamthebestuk]

Hi,

I have a list of dates to which I want assign quarters ie. Current Quarter, Quarter-1, Quarter-2, Quarter+1, Quarter+2 etc.

For example, on the left we have the dates and on the right we have the quarter it refers to.

01/01/2006 Current Quarter
31/12/2005 Quarter -1
15/06/2006 Quarter +1
15/08/2005 Quarter -2


Does anyone know who this can be done?



Power is Knowledge
Knowledge is Power

 

[PHV]

A starting point:
'Quarter ' & DateDiff('q',Date(),[yourDateField])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886