[Variable Mapper]Date/Time Exists

Logic Name

Date/Time Exists

Function

Determines whether the input date/time exists.

Data Types

Location	Type
The first input handler	String
Logic output	Boolean

Refer to "Logic Specifications" for details.

Properties

Category	Property	Description
Required	Format	Specify input format.
Null processing	Null option	Specify how to handle the input if it contains null.
Comment	Comment	The comment will also be output to the specifications.It does not affect the conversion process.

Null option

Option	Description
Return false when unable to determine/calculate/process	Continues with the process when unable to determine/calculate/process without throwing exception.
Throw exception when unable to determine/calculate/process	Throws exception (CalculationException) when unable to determine/calculate/process.
Output null if any input is null	Outputs null if the value of any input handler is null.

Refer to "Logic Specifications" for details.

Notes

About Criteria
The criteria for whether the date/time exists are the result of analyzing with the format.
The validation of the format cannot be checked with this logic.
Therefore, the result for a date format that does not meet the intended format may still be true.
An example is shown as follows.The format is intended to be "yyyyMMdd".

Input date/time	Determination result	Description
20080101	true	It is interpreted as January 1, 2008.
a20080101	false
20080101a	true	It is interpreted as January 1, 2008.
2008101	true	It is interpreted as October 1, 2008.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

Processes input data in the "yyyy-MM-dd" format. If the date exists, return "true". If not, return "false".

Property Settings

Property	Setting
Format	yyyy-MM-dd
Null option	Return false when unable to determine/calculate/process

Input Data

1999-09-31

2004-10-17

2009-13-10

Result Data

false

true

false