If-Then-Else help required 1

[Mags2010]

I am working with the following formula & don't know where I am going wrong.

If(DayOfWeek(currentdate)=2)
then
({@IMP Date} = (currentdate-2))
else
{@IMP Date} = (currentdate);
{TRADEPAY.RRProductionCredit}
although the formula works it is not returning the value I need.

My record selection is identified below because I have a daily, MTD & YTD Commissions column:

{TRADES.TradeDate}>=(if(month(currentdate)>10)
then
dateserial(year(currentdate),10,1)
else
dateserial(year(currentdate)-1,10,1))

Any assistance is appreciated

 

[lbass]

If DayOfWeek(currentdate)=2 then
(
if {@IMP Date} = currentdate-2 then
{TRADEPAY.RRProductionCredit}
)
else
(
if {@IMP Date} = currentdate then
{TRADEPAY.RRProductionCredit}
)

-LB

 

[Mags2010]

Thank-you so much! It worked!