Current Date Formula 1

[Croaks]

Hi i need to use the current date formula to find out what month the report is run and then perform a calculation on a value based on what month it. Ie.. If its Feb i need to / by 2, March /3 and so on

what ive got so far is:

IF CurrentDate = 2004/01/01 THEN True to 31/01/2004 Then ({Operatives.TARGETTURNOVER}) / 2

Help please!!


Cheers

Croaks

 

[MadCatmk2]

Hi Croaks

Not to sure if this is what your looking for but:

you may be able to use

({Operatives.TARGETTURNOVER}) / month(currentdate)

the month() formula should return the month number.

HTH

 

[Croaks]

Thats great, exactly what i was after

Thankyou