Icon

Challenge 5 - Date to Fiscal Year

Challenge 5 - Date to Fiscal Year
Description: In the accounting firm you work for, you are given contracts which were executed on different dates. Your goal is tocreate a method that can label each of these contracts with their corresponding fiscal year. Note: A fiscal year is a period of 12months that is used in government accounting, usually for budget purposes and financial reporting. Its definition varies fromcountry to country, so your solution should be flexible and include flow variables for both the start and the end dates of the fiscalyear. As an example, the federal fiscal year in the United States is the 12-month period that begins on October 1st and ends onSeptember 30th of the following year.Author: Victor PalaciosDataset: Labels for fiscal years and contract dates in the KNIME HubSolution:this workflow generate the fiscal year column based on contract date and fiscal year start date Contract DatesEnterFiscal YearStart DateAdd FYNode 13 Excel Reader Date&TimeConfiguration Extract Date&TimeFields Variable toTable Row String to Date&Time String to Date&Time Extract Date&TimeFields Table Rowto Variable Column Expressions Column Filter Description: In the accounting firm you work for, you are given contracts which were executed on different dates. Your goal is tocreate a method that can label each of these contracts with their corresponding fiscal year. Note: A fiscal year is a period of 12months that is used in government accounting, usually for budget purposes and financial reporting. Its definition varies fromcountry to country, so your solution should be flexible and include flow variables for both the start and the end dates of the fiscalyear. As an example, the federal fiscal year in the United States is the 12-month period that begins on October 1st and ends onSeptember 30th of the following year.Author: Victor PalaciosDataset: Labels for fiscal years and contract dates in the KNIME HubSolution:this workflow generate the fiscal year column based on contract date and fiscal year start date Contract DatesEnterFiscal YearStart DateAdd FYNode 13 Excel Reader Date&TimeConfiguration Extract Date&TimeFields Variable toTable Row String to Date&Time String to Date&Time Extract Date&TimeFields Table Rowto Variable Column Expressions Column Filter

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: tarekahmedfarouk
Created at: 2022-02-23
On NodePit since: 2022-02-24
Last update: 2024-04-27
Created with KNIME version: v4.5.1
Tags: justknimeitjustknimeit-5fiscal year

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

Try NodePit Runner!