Search results for query: *

Nevermind I finally got it. It turns out that is not the same ELSE IF than to type ELSE and in the next line start it with an IF. Code came out like this: if not isnull({CLOSING.CLEAR_TO_CLOSE}) and {CLOSING.CLEAR_TO_CLOSE} < {@100 dias} then "08 Clear to Close" else if not...

Yes that's exactly what I'm trying to do. From the last possible to the first. But still it appears that when I use an IF and then ELSE it only takes those 2 posible answers and does not take notice for the next ones. It will only "evaluate" the first IF and what follows the ELSE. As for crystal...

Hey! thanks again for helping me. Well yes its only 1 status per record. but the thing is that there are 8 status available including clear to close and approved. And so with 1 else yes I can use these 2 IF's as you typed the formula. But what if there are more than 2 IF? I tried with more than...

For not to open a new thread. I was tryin on the same report to create a formula string field that will populate depending on conditions of datetime fields. What I wanna do is populate this field depending on datetime fields on the database that are filled and if are greater or smaller than that...

Wow thanks man!. I think I'm kinda blocked today. hehehe Thanks again.! Amazing how questions that seem complex have simple answers.

One other question. I was trying to enter a parameter field (numeric) that will ask me for the number of days. and then create a formula field ({@days})that will assume (CURRENTDATE - {?days}) So that it will calculate {@days} before reading the records. It is working and it displays the...

Thanks! I think is was missusing the or by putting all on the same line and also by not using the () like you did. Many many thanks man! Problem solved!

Hi. I'm trying a formula to select data parting from several conditions. Explanation: Notes: {@100} is a simple forumla that says: CURRENTDATE - 10. 1. OPENDATE: is a Date where a record is entered. This is a datetime field and the condition on this field is that it has to be smaller than...