Recently upgraded (last week) from WF 7.6.4. to 7.6.8 - upgrade went extremely smooth. Windows Server 2003

Since then - I am finding defines that DO NOT work the way they did in previous versions of WF.

In the define below - if the AW_UNOFF_REVISED_DELIVERY_DT or the AW_OFFICIAL_REVISED_DLVRY_DT
are blank or missing this define thinks they are greater than the AW_ORIG_DELIVERY_DT and it uses a blank
for the DELIVERY_DT - this causing MAJOR problems. Is anyone else having the same problem?


DEFINE FILE AWHEADER
-* This algorithm will calculate the newest delivery date
DATE1/YMD = IF AW_ORIG_DELIVERY_DT GT AW_UNOFF_REVISED_DELIVERY_DT THEN
AW_ORIG_DELIVERY_DT ELSE AW_UNOFF_REVISED_DELIVERY_DT;
DELIVERY_DT/YMD = IF DATE1 GT AW_OFFICIAL_REVISED_DLVRY_DT THEN
DATE1 ELSE AW_OFFICIAL_REVISED_DLVRY_DT;
END

This message has been edited. Last edited by: Kerry,

quote:

if the AW_UNOFF_REVISED_DELIVERY_DT or the AW_OFFICIAL_REVISED_DLVRY_DT are blank or missing...

AW_ORIG_DELIVERY_DT GT AW_UNOFF_REVISED_DELIVERY_DT
and
DATE1 GT AW_OFFICIAL_REVISED_DLVRY_DT
evaluate to False if either operand is MISSING.

If the _DT fields have MISSING ON, convert them first to /YYMD dates with MISSING OFF (which will effectively map Missing to low-values), than use MAX( , , ).

quote:

AW_ORIG_DELIVERY_DT GT AW_UNOFF_REVISED_DELIVERY_DT
and
DATE1 GT AW_OFFICIAL_REVISED_DLVRY_DT

I was hoping there would be a GLOBAL fix - since I have a bazillion of these fexes!

Seems like this is a bug in 7.6.8.

First you have to delineate the problem.

What are the Format and Missing attributes of the date fields?

How many such fields from how many masters are involved in the bazillion fexes?

You may be able to centralize the fixes to the MFD(s), or your service routines that supply standard Defines.

Interesting that this seems to be an upgrade issue for you. This is the way that WF has always worked, as jgross suggests. The DEFINE cannot evaluate an equality test if either field is missing, so it always returns false. Maybe some master files have been regenerated in the process of the upgrade and have lost their MISSING attribute or a DEFINE or something like that.