Top
Top
LibraryEASYProcess Reference Manual 5ProcessesServicesDateTimeWorkshopConvertFromJDEDate

 ConvertFromJDEDate Overview

This service is used to take in a JDEDate and output the results in various different formats. This must take only the JDE Date (no time value appended after a space as other services accept). Since the service accepts no time value, the time cannot be converted with this service. This means the datetime it outputs will have 00:00:00 as the time value.


ConvertFromJDEDate Use Examples
Workshop:DateTimeWorkshop
Service:ConvertFromJDEDate
Inputs
SeparatorThe Default value is /. This can be changed to another character, like a dash (-) for example. Some of the output dates use this separator value. Valid Separator values: "/", ":", "-"

JDEDateThe JDE Date which we will be converting.

Outputs
DateEx: 12/17/2018.
DateTimeSince this contains AM/PM, it is a 12 hour format. Ex: 12/17/2018 12:40:34 PM.
DayDay portion of the date. Ex: 17. This is the 17th day of the month.
DayOfMonthEx: 17. This is the 17th day of the month.
DayOfWeekEx: Monday.
DayOfYearEx: 351. This is the 351st day of the year.
EPLongDateThe time is in a 24 hour format. Ex: 2018/12/17 12:40:34. 2018/12/17 13:04:22.
EPShortDateEx: 2018/12/17.
HourHour portion of the time. This is a 24 hour format. Ex: 12. This is the 12th hour. If it were 1pm, the hour would be 13.
JDEDateJDE Date format. The format is C-YY-DDD: the century after 1900, the year in that century and the Julian date within that year. Ex: 118351. This is the first century after 1900 (1). The year is 2018 (18). It is the 351st day of the year (351). Together this creates the 118351 JDE Date.
JDETimeJDE Time format. the format is HH-MM-SS. Ex: 124034. This is 12:40 and 34 seconds. This is a 24 hour format. 1:05pm would be 130500
LongDateEx: Monday, December 17, 2018.
MillisecondEx: 471. This is when the full time of day is 12:40:34.4712406.
MinuteMinute portion of the time. Ex: 40. This is the 40th minute of the hour.
MMDDYYThe separators used are determined by the separator value passed in the input. Ex: 12/17/18.
MMDDYYYYThe separators used are determined by the separator value passed in the input. Ex: 12/17/2018.
MonthMonth portion of the date. Ex: 12. This is the 12th month of the year.
MonthNameThe spelled out month of the year. Ex: December.
SecondSecond portion of the time. Ex: 34. This is the 34th second of the minute.
ShortDateEx: 12/17/2018.
TimeOfDayThis is a 24 hr format. Ex: 12:40:34.4712406. Another Example at 1:05pm: 13:05:22.5915047.
YearYear portion of the date. Ex: 2018.
YYMMDDThe separators used are determined by the separator value passed in the input. Ex: 18/12/17.
YYYYMMDDThe separators used are determined by the separator value passed in the input. Ex: 2018/12/17.

ConvertFromJDEDate Use Examples

Basic Use Example

If we are always going to receive a JDEDate and would like it in different date formats, we can use ConvertFromJDEDate. The service takes in the JDEDate and a separator character value. Here is the service configured for two different separator characters:

Here are the outputs:

Since the service accepts no time value, the time cannot be converted with this service. Notice the time in the datetime returned is 00:00:00.


Powered by EASYProcess (© 2019 K-Rise Systems, Inc).