AnsweredAssumed Answered

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

Question asked by Gert on Feb 25, 2010
Latest reply on Feb 25, 2010 by TSGal

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.

Outcomes