Project

General

Profile

Bug #11904

INITIAL in a schema .df file follows 'mdy' format

Added by Constantin Asofiei about 12 hours ago. Updated 2 minutes ago.

Status:
WIP
Priority:
Normal
Assignee:
Ovidiu Maxiniuc
Target version:
-
Start date:
Due date:
% Done:

0%

billable:
No
vendor_id:
GCD
case_num:
version_reported:
version_resolved:
reviewer:
Constantin Asofiei
production:
No
env_name:
topics:

History

#2 Updated by Constantin Asofiei about 12 hours ago

In #11871 project, the .df file uses 'mdy' format, INITIAL "7/27/2026", for a datetime field.

The database is ran with 'dmy' format in 4GL.

We need to confirm via tests that:
  • either this was a TODAY format which was exported wrong
  • the schema INITIAL date format always follows 'mdy', regardless on how you run the 4GL database

#3 Updated by Ovidiu Maxiniuc 2 minutes ago

  • Assignee set to Ovidiu Maxiniuc
  • Status changed from New to WIP
  • reviewer Constantin Asofiei added

According to Progress Documentation, "The date constants entered in procedures, or as initial values in the Data Dictionary, are always specified in month/day/year format." It is not affected by SESSION:DATE-FORMAT attribute or by Date Format (-d) command-line parameter.

I also manually tested by starting the process with different date formats and exporting the database schema. In all cases the resulting .df file was identical.

I am looking at FWD implementation of data-related fields based on initial value, next.

Also available in: Atom PDF