Kbase P136136: Using DATE field or variable in MESSAGE statement always uses standard format
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2008 |
|
Status: Unverified
SYMPTOM(s):
Using DATE field or variable in MESSAGE statement always uses standard format
DATE field/variable has a specific format string set (ie: "99-99-9999").
Using this DATE field/variable in a message statement shows it with "99/99/99" format.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
This is expected behavior.
The MESSAGE statement ignores the FORMAT phrase for fields/variables, and applies only minimal formatting to the values displayed.
FIX:
Use the STRING function to apply the appropriate format.
For example:
MESSAGE STRING(TODAY,"99-99-999").