1 Reply Latest reply on Feb 25, 2010 7:36 AM by TSGal

    Replace field contents with functions min or  max(date;{; veld...} ) ) gives number instead of date

    Gert

      Summary

      Replace field contents with functions min or  max(date;{; veld...} ) ) gives number instead of date

      Description of the issue

      FM Pro 10.0v3 Windows 'Replace field contents' with functions min or max in the form max(date1) or max(date1;date2) gives a number (like 733829) instead of a date. date1 and date 2 are of type 'date'Destination field is of type 'date'Type of calculation result is 'date' When used manually from the menu, the behaviour is consistent. When used as script step the behaviour is not always the same;one file has a script that stores the maxvalue in a variable, adds an integer, then stores the result: a nice dateonother file has a script that simply replaces the field value but never gets a nice formatted date as result.