Icon

DateToFiscalYear

In the accounting firm you work for, you are given contracts which were executed on different dates. Your goal is to create a method that can label each of these contracts with their corresponding fiscal year.

Note: A fiscal year is a period of 12 months that is used in government accounting, usually for budget purposes and financial reporting. Its definition varies from country to country, so your solution should be flexible and include flow variables for both the start and the end dates of the fiscal year. As an example, the federal fiscal year in the United States is the 12-month period that begins on October 1st and ends on September 30th of the following year.

contract_datesfiscal yearsevery x everyinbound = truetrue onlycontract_datesout of rangecontract_dateswith fiscal keyExcel Reader Excel Reader Choose thefiscal year String to Date&Time Cross Joiner Column Expressions Row Filter ReferenceRow Filter Column Filter Component contract_datesfiscal yearsevery x everyinbound = truetrue onlycontract_datesout of rangecontract_dateswith fiscal keyExcel Reader Excel Reader Choose thefiscal year String to Date&Time Cross Joiner Column Expressions Row Filter ReferenceRow Filter Column Filter Component

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: stan
Created at: 2022-02-23
On NodePit since: 2022-02-24
Last update: 2024-04-28
Created with KNIME version: v4.5.1
Tags: justknimeit-5justknimeit

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!