Consultor Eletrônico



Kbase P100690: DATE Function returns unknown (?) value
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   04/10/2005
Status: Unverified

FACT(s) (Environment):

OpenEdge 10.x
Progress 9.x

SYMPTOM(s):

DATE Function returns unknown (?) value

The argument of the function is a variable of data type DATE

The argument of the function is a widget INPUT-VALUE attribute

This works fine in version 9

CHANGE:

Migrated to OpenEdge 10

CAUSE:

This is expected behavior, the DATE Function does not accept a DATE as argument.
In version 9 this use to work when used with the INPUT-VALUE attribute, because, due to a bug the return from the INPUT-VALUE was converted to a CHAR.

FIX:

Cast the argument of the function to a string before using it.
DATE (STRING(myValue))

instead of

DATE (myValue)