I HAVE A QUERY IN WHICH I MADE 3 EXPRESSIONS.
WE ARE TRYING TO CALCULATE PROCESSING TIMES FOR FORMS.
EXPR 1 IS DATE OF FI MINUS DATE OF FILING.
EXPR 2 IS DATE OF CLOSURE MINUS DATE OF FILING
EXPR 3 IS LAST INPUT DATE MINUS DATE OF FILING
IN THE PROCESSING LINE, IF THEY HAVE AN FI, THAT IS THE SHORTEST AMOUNT OF PROCESSING TIME, IF THEY CLOSED THEN THAT IS THE SECOND LONGEST PROCESSING TIME AND IF THEY HAD NEITHER OF THOSE, THEN IT WAS STILL IN PROCESSING UP TO THE DATE OF LAST INPUT. SO I WANT TO CREATE AN EXPRESSION THAT WILL PRINT THE VALUE IN EXPR 1, IF IT'S BLANK THEN PRINT THE VALUE IN EXPR 2, AND IF THAT IS ALSO BLANK THEN PRINT WHAT IS IN EXPR 3.
SO, I'M THINKING AN IF/THEN LOOP?
SOMETHING LIKE:
IF <<EXPR1>>IS NOT NULL <<EXPR1>>, THEN (IF <<EXPR2>> IS NOT NULL <<EXPR2>>, THEN <<EXPR3>>)
I CAN'T FIGURE OUT HOW TO GET THE SYNTAX ALL CORRECT TO MAKE IT WORK.
CAN ANYONE OFFER ANY ASSISTANCE?
THANKS!
WE ARE TRYING TO CALCULATE PROCESSING TIMES FOR FORMS.
EXPR 1 IS DATE OF FI MINUS DATE OF FILING.
EXPR 2 IS DATE OF CLOSURE MINUS DATE OF FILING
EXPR 3 IS LAST INPUT DATE MINUS DATE OF FILING
IN THE PROCESSING LINE, IF THEY HAVE AN FI, THAT IS THE SHORTEST AMOUNT OF PROCESSING TIME, IF THEY CLOSED THEN THAT IS THE SECOND LONGEST PROCESSING TIME AND IF THEY HAD NEITHER OF THOSE, THEN IT WAS STILL IN PROCESSING UP TO THE DATE OF LAST INPUT. SO I WANT TO CREATE AN EXPRESSION THAT WILL PRINT THE VALUE IN EXPR 1, IF IT'S BLANK THEN PRINT THE VALUE IN EXPR 2, AND IF THAT IS ALSO BLANK THEN PRINT WHAT IS IN EXPR 3.
SO, I'M THINKING AN IF/THEN LOOP?
SOMETHING LIKE:
IF <<EXPR1>>IS NOT NULL <<EXPR1>>, THEN (IF <<EXPR2>> IS NOT NULL <<EXPR2>>, THEN <<EXPR3>>)
I CAN'T FIGURE OUT HOW TO GET THE SYNTAX ALL CORRECT TO MAKE IT WORK.
CAN ANYONE OFFER ANY ASSISTANCE?
THANKS!