convert JD Edwards Julian Date format to date(text a, default b)

Group

Date functions


The function converts a JD Edwards date into a date (Date object) without time component.

Description of Parameters


Parameter

Description

a

JD Edwards date to be converted.

b

(optional) Controls the behaviour if a cannot be read as JD Edwards date. Default: empty.

empty

The current date with set Empty Flag is returned.

error

The mapping is aborted with an error.

now

The current date is returned.

Examples


Parameter a

Parameter b

Result

121011


2021-01-11

abc


Today's date with set Empty Flag .

abc

now

2021-01-13 (today's date)