I have following calculations : amount*number_of_days_in_a_month / number_of_days_in_a_year.
I don’t know to to introduce into calculation a leap year (29 days for February and 366 days if it is a leap year and 28 days for February and 365 days in a year if it is a normal year.
I have a column with indication of a year
I created a table where I wrote how many days are in a month (31 days for January…31 days for February).
hi, Alexander, many thanks for answering. Could you please give more details? I can’t get what “calculate the number of days from 1.1. to 1.1.<year+1>” can practically mean?
hi, data will be updated on a monthly basis and the end user will not have access for a workflow. I don’t think that creating a Date&Time Difference node.
Hi,
the answer is my screenshot. You need the Date&Time Difference Node and prior to the Node specific Date calculations based on your data record. This are for the days of month calculation the 1st of the current month and 1st of the next month (see Row1 or Row 3) respecticely for the year calculation the 1st of january of the current year and the 1st of january of the next year.
To get these dates you can solve it using different nodes or solve it with one java snippet node.