Date Formula Help

[ecugrad]

I'm trying to write what I hope is a simple comparison statement. I have field called ProbEnd (End of Probation). We pay incentive if the employee has completed their probation and compltes other qualifiers. Below is what I'm trying to accomplish
If the ProbEnd date is less than the 15th of the prevous month(current month - 1) than [Salary] Else 0

Using CR 8

Thanks for any help...

 

[lbass]

if {table.probenddate} < dateserial(year({table.probenddate}),month({table.probenddate})-1, 15) then
{table.salary} Else 0

-LB

 

[kskid]

I think you want to use currentdate instead of {table.probenddate}

if {table.probenddate} < dateserial(year(currentdate),month((currentdate})-1, 15) then
{table.salary} Else 0

-LW

 

[lbass]

Oops, yes, kskid is correct.

-LB