PQL46 (PQL Function Library - CPM 4.6)PQL 46Functions and operatorsDateTimeDateTime projectionYEARYEARApplies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6DescriptionReturns the year of a given date.Supported input column types: DATEOutput column type: INTSyntaxYEAR ( table.column )NULL handlingIf any parameter is NULL, the result is NULL as well.Example[1] Simple example for the YEAR operator.QueryColumn1YEAR ( "Table1"."Column1" )InputOutputTable1Column1 : DATEMon Jan 01 2018 00:00:00.000Mon Jan 01 2018 00:00:00.000Tue Jan 01 2019 00:01:50.700ResultColumn1 : INT201820182019