MemoryFormat (Property)

The format of the displayed value (called input mask): this format is used to display the date or the time in the edit control.
The format of the value returned by the program or transferred into an item.

If the input mask and the returned value are not identical, the conversion is automatically performed when saving the associated record.

The format of returned value is typed in the window editor, in the "Details" tab of the description window of Date or Time edit controls.

..MemoryFormat is used to find out and modify the format of the value returned for:

the Date or Time edit controls.
the columns of the Date or Time Table controls.
Calendar controls.
Versions 15 and later
the Static controls.
New in version 15
the Static controls.
the Static controls.
Versions 17 and later
the editable Combo Box controls.
New in version 17
the editable Combo Box controls.
the editable Combo Box controls.
Versions 17 and later
the columns of the Table controls displayed by Combo Box controls.
New in version 17
the columns of the Table controls displayed by Combo Box controls.
the columns of the Table controls displayed by Combo Box controls.

Versions 21 and later

This property is now available in Universal Windows 10 App mode.

New in version 21

This property is now available in Universal Windows 10 App mode.

Example

EDT_Date1..MemoryFormat = "YYYMMDD"
Trace(EDT_Date1) // Will display 20010702
EDT_Date1..MemoryFormat = "MM/DD/YYYY"
Trace(EDT_Date1) // Will display 07/02/2001
EDT_Time1..MemoryFormat = "HH:MM"
Trace(EDT_Time1) // Will display "14:31"
EDT_Time1..MemoryFormat = "HHMMSS"
Trace(EDT_Time1) // Will display "143123"

Versions 17 and later

// Stored format of a Combo Box control displaying a list
Trace(COMBO_ListEdit..MemoryFormat)
COMBO_ListEdit..MemoryFormat = "YYYMMDD"
Trace(COMBO_ListEdit..MemoryFormat)

// Combo Box displaying a table
// Stored format of a Date column in a Table control
Trace(COMBO_TableEdit.COL_DateCol..MemoryFormat)

New in version 17

Syntax

Finding out the returned value Hide the details

<Returned value> = <Control used>..MemoryFormat

<Returned value>: Character string

Format currently used for the returned value of the specified control.
For edit controls and columns of a Table control, the "As is" option is selected if this parameter corresponds to an empty string (""): in this case, the returned value corresponds to the input mask (returned by ..InputMask).
For the Calendar controls, the default format is used ("YYYYMMDD") if this parameter corresponds to an empty string ("").

<Control used>: Control name

Name of control used:
"Date" or "Time" edit control,
"Date" or "Time" column of a Table control,
Calendar control.

Modifying the returned value Hide the details

<Control used>..MemoryFormat = <New format>

<Control used>: Control name

Name of control used:
"Date" or "Time" edit control,
"Date" or "Time" column of a Table control,
Calendar control.

<New format>: Character string

New format used for the returned value of the specified control.
For edit controls and columns of a Table control, the "As is" option is selected if this parameter corresponds to an empty string: in this case, the returned value corresponds to the input mask (returned by ..InputMask).
For the Calendar controls, the default format is used ("YYYYMMDD") if this parameter corresponds to an empty string ("").

Remarks

Limits

..MemoryFormat only applies to:

"Date" and "Time" edit controls.
"Date" and "Time" columns of a Table control.
Calendar controls.
Versions 15 and later
Static controls.
New in version 15
Static controls.
Static controls.
Versions 17 and later
editable Combo Box controls.
New in version 17
editable Combo Box controls.
editable Combo Box controls.
Versions 17 and later
columns of a Table control displayed by Combo Box controls.
New in version 17
columns of a Table control displayed by Combo Box controls.
columns of a Table control displayed by Combo Box controls.

..MemoryFormat only applies to the edit controls.