CONCAT_DATE - Returns a DATE value from Year, Month and Date

Help Contents

Introduction

Converts a Year, Month and Date value into a calendar date.

Syntax

Informal Syntax:

CONCAT_DATE( Year, Month, Date )

Formal Syntax:

CONCAT_DATE( Year:=expression, Month:=expression, Date:=expression )

Parameters

ParameterTypeDescription
YEARANY_INTThe year value. The valid range of this parameter is 1601 to 9999
MONTHANY_INTThe month value. The valid range of this parameter is 1 to 12.
DATEANY_INTThe date value. The valid range of this parameter is 1 to 31.

Return Value

The function CONCAT_DATE returns a DATE value, the result of converting a Year, Month and Date to a calendar date.

Examples

ExampleReturn Value
CONCAT_DATE( 2020, 8, 23 )D#2020-08-23

Standards Compliance

Table 36.2a - IEC 61131-3 Third Edition.

Further Information

Date and Time Functions

For other date and time functions.

Glossary

For the meaning of terms used in Fernhill SCADA.