|
Working with Date/Time Format Process |
  
|
Working with Date/Time Format Process
|
Working with Date/Time Format Process |
|
Process Purpose
The Date/Time Format process is used to convert a given date/time into a specific format. The result is stored in a variable.
Check the provided Date/Time Format examples at the end of the topic.
When you add a process, you are required to define its settings. This occurs in the process's properties window which is displayed automatically after having added the Date/Time Format process.
If any subsequent edition is required, double-click the process to open its properties window and enter the necessary modifications.
Proceed as follows:
Input |
|
Format |
Select an input format from the drop-down list or enter it with the use of a syntax list that is accessed by clicking
The "System Format" option is only available to define a "Date" format. |
Date |
Enter the input value of the date or time that will be formatted or click |
Result |
|
Format |
Select the output format for the result from the drop-down list or enter it with the use of a syntax list that is accessed by clicking
The "System Format" option is only available to define a "Date" format. |
Result Variable |
Click |
If required, use the icon on the upper right corner of the properties window:
Use the icon to attach any relevant notes to this process. Click it and enter your notes in the resulting text box. These notes will be displayed in the corresponding "Actions" tab or "Process" window (in the "Notes" field) and in the "Developer Report".
After filling in the required options, click 
to conclude or 
to abort the operation.
The added process is displayed in the corresponding "Actions" tab or "Process" window.
If the source value for the date format is invalid (ex: b9F00) or left blank, the date format will display "99/99/9999".
Use the right click in MCL-Designer's input boxes to access certain features regarding the input box's option as well as general actions such as "Copy"; "Paste"; "Search".
Ex: If you right-click the "Variable" input box (included in a "Conversion's" properties window), you are provided with the "Search..."and "Variable Select" options.
If you right-click another input box, it will provide other possibilities.
 | Example 1 - Input format = Date and Time (DD/MM/YYYY HH:MM:SS) >> output format = Date (YYYY/MM/DD) |
Input Format: %D/%M/%Y %H:%N:%S Input: 10/05/1998 19:23:03
Output Format: %Y/%M/%D Corresponding Output: 1998/05/10
|
| Example 2 - Input format = Date and Time (YYYYMMDDHHMMSS) >> output format = Date (YY/MM/DD) |
Input Format: %Y%M%D%H%N%S Input: 20160101233407
Output Format: %Y/%M/%D Corresponding Output: 16/01/01
|
| Example 3 - Input format = Date (YYYY-MM-DD) and Time (HH:MM:SS) >> output format = Date (D/M/YY HH:MM:SS.MS) |
Input Format: %Y-%M-%D %H:%N:%S Input: 1997-04-09 14:23:03
Output Format: %d/%m/%Y %H:%N:%S.%L Corresponding Output: 9/4/1997 14:23:03.000
|
| Example 4 - Input format = Date (DD/M/YY) >> output format = Date (DD/MM/YYYY) |
Input Format: %d/%m/%y Input: 10/5/98
Output Format: %D/%M/%Y Corresponding Output: 10/05/1998 |
. This format needs to match the format of the date/time value from the "Date" variable value. 
and select a variable with that value. See 
to define the variable that will receive the result value. See 
