There is a date field that for years we have used as a date the product actually shipped from our facility even though the value of the date field was the "PLANNED RELEASE DATE" for the manufacturing order. Since we do not enter the order until it is released, we've never used this field for it's intended use.

Now due to an update to the software, this is now a REQUIRED field. As a work around, we are planning to use a date of 01/01/2005 and then put the acatual ship date in as we have always done in the past. I've coded the report appropriately that says if the "PLANNED RELEASE DATE" is 01/01/2005 to put NOT SHIPPED in a define field that show a MO as ON TIME, LATE, or NOT SHIPPED. The only issue {and it is only a cosmetic issue} is that no one likes to see the 01/01/2005 date on the report.

KEEPING IN MIND THAT I CAN ONLY USE INFO ASSIST due to political reasons from corporate, is there a way I could DATA, DEFINE, to not show the 01/01/2005 date? When I pull up DEFINE, I have to give it a format, so I use MDYY, and in the text I put

IF PLANNED_RELEASE_DT EQ '01/01/2005' THEN

but didn't know what to put after that?

This message has been edited. Last edited by: <Kathryn Henning>,

Your obviously "MISSING" something

DEFINE FILE CAR
   SALES_RTFM/D12 MISSING ON = IF SALES NE 0 THEN SALES ELSE MISSING;
END

TABLE FILE CAR
   SUM SALES
       SALES_RTFM
   BY  CAR
END

Cheers,
Dave

Oh...

and you'll find that under the "options".

"Override missing values handling" somewhere

quote:

Originally posted by Dave:
Oh...

and you'll find that under the "options".

"Override missing values handling" somewhere

In don't think, there is something like that in pure InfoAssist without any chance to edit code.

Indeed....

...I only use Dev.Studio. I assumed such a basic feature would be available in de InfoAssist.


WTF?
( Where's The Field-option-button )

Anybody?

Hello Pops,

if you like to have an 'empty' field instead of the date 01/01/2005 within
Info Assist, the easiest way: Data/Detail Field (Define)
Field: Newfieldname, Format: A10 ( Character format instead of date format)
IF yourDate EQ '01/01/2005' then '' ELSE yourDate

But , if you need the date format for the output field this solution does not work

Bernd

Thanks everyone...

As mentioned above, without EDIT TEXT option, which is nothing but a political issue with the IT folks who can't stand the fact that someone who is not an IT person has enough brainpower to write their own reports???... but I digress..

What I ended up doing was IF, THEN... If date equals 01/01/2005 then pull "this field" and used a field that was not used in our business and pthe ELSE was the date if is wasn't 01/01/2005.

There is always a way.

Thanks everyone!