active/inactive ads

[HeatherSayers]

I need some HELP!

We use FileMaker Pro 4

We have a classified database and I can't get the issue number to show as an active ad.

Status: should be active

If(CatFlag="S" or CatFlag="H","ACTIVE HEADING",If(WeekofYear(Today+5)-1 * Start Issue No. and WeekofYear(Today+4)-1 * End Issue No. or (End Issue No.<Start Issue No. and Start Issue No.+Run For>51),"ACTIVE",If(Classification Number="99","ACTIVE",If(WeekofYear(Today)=End Issue No. and PAY METHOD*"FREE","ACTIVE","INACTIVE"))))

Start No.: should be 2

If((DayName(Date Entered)="Sunday" and Time Entered >61200), WeekofYear(Date Entered+5),WeekofYear(Date Entered+4))

End No.: should be 3

If(Run For="99" or CatFlag="H" or CatFlag="S",99,If((Start Issue No.+Run For-1)>51,Start Issue No.+Run For-1-51,Start Issue No.+Run For-1))+2-2

Run For: 2

Indexed, Auto-enter Data

I think these are only fields that are messy things up.

So, all the new ads we enter til Tuesday should be as above, but they are not, they are showing inactive in the status field - so of course our exporting will not be correct.

I HOPE SOMEONE CAN HELP ME

THANKS HEATHER

[birdman]

Heather,

I noticed that part of your first calculation has asterisks in it:

If(WeekofYear(Today+5)-1 * Start Issue No. and WeekofYear(Today+4)-1 * End Issue No.

Was this on purpose or by accident in your post? I can't help think that there should be an evaluation of some sort going on in these instances, perhaps:

If(WeekofYear(Today+5)-1 = Start Issue No. and WeekofYear(Today+4)-1 = End Issue No.

If there is no evaluation being done then I believe this part of your calculation will always result in a "true" answer to your IF statement, hence "ACTIVE".

Hope this helps.