IS – Validate input type
This function confirms if the input data belongs to the specified data type. It returns 1 if the answer is affirmative. On the contrary, it returns 0.
IS(<type>,<value>)
Where:
<type>
- The type of field. Allowed values are:
- DATE
- Date in the format YYMMDD
- IA
- Input arrival in the format YYMMDDHHMM
- LABEL
- Workload Automation Programming Language label
- OBJECT
- Workload Automation Programming Language object name
- TIME
- Input arrival in the format HHMM
- VARNAME
- Workload Automation Programming Language variable name
<value>
- The data for whose type you want to determine.
For example, the following command returns
0
:
IS(“DATE”,211324)
The following command returns
1
:
IS(“TIME”,2359)
While DATE
and TIME
rely on a specific input
format, you can use DATEFORM
to convert the input for testing. For
example:
The following command returns
0
:
IS("DATE",DATEFORM(311321,"DDMMYY","YYMMDD"))
The following command returns
1
:IS("DATE",DATEFORM("31/10/21","DD/MM/YY","YYMMDD"))
The following command returns
1
:IS("TIME",DATEFORM("21:12","HH:NN","HHNN"))