Top
Top
LibraryEASYProcess Reference ManualProcessesServicesDateTimeWorkshopConvertToJDEDate

ConvertToJDEDate Overview

This service is used to take in a YYYYMMDD date and output the results in other date formats including JDEDate. This must take the date in only the YYYYMMDD format. It can also accept an appended time after a space ([YYYYMMDD] [Time]) such as the format of EPLongDate.


ConvertToJDEDate Use Examples
Workshop:DateTimeWorkshop
Service:ConvertToJDEDate
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: "/", ":", "-"

YYYYMMDDThe Date we will be converting to JDEDate. This must start at the YYYYMMDD format.

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.

ConvertToJDEDate Use Examples

Basic Use Example

If we have a EPLongDate or YYYYMMDD date format and would like a JDEDate format, we can use the ConvertToJDEDate service. Here is the service configured a couple different ways:

 

Notice how it doesn’t require the time, but if it is not given the JDETime is returned as 000000.


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