Current date formula. 1

[mudflap]

I have a field I am trying to do this with.

if (prepress wip(b.duedate) = current date then



What I want it to do is print out the one that equal the current date..What goes after then .
The formula works but just need the last part to tell me
what jobs are due or atleast the total that are due today.

Thanks

Peter

 

[mudflap]

Ok, heres what I have.

A formula called new with your above in it.
The I have a formulae calling that formula..
But the problem is, it is called job...Which means it is using the original formula I used to just give me the due today stuff..I want it to give me past info and use that
formula you used.

Sorry I am such a pain in the a**

 

[Naith]

You can't recycle a variable name for another task. Crystal will rightly think you're referring to the same variable as before.

This thread is getting pretty long, so I think you should detail *exactly* what you want in an email, and whether you'll settle for a count of records, if you simply can't have an inventory because of the 254 limit, and send it to me.

Thanks,

Naith

 

[mudflap]

Ok, I tried that report..Nothing happens..So
I copied over the formulas to a report I was working on for more orgranzided look..But is giving me that 254 error on the formula that calls job2?

Weird any ideas.

I owe you !!!