I have created attached workflow to calculate the “last date” and “first date” for any date of any given month, however, in cases of leap years, last day of February is being calculated as 28th instead of 29th.

I am out of ideas on how to fix that,

End of month date.knwf (25.9 KB)

Hi @ali_aff, I haven’t worked through your flow to see where the error is, but here is an alternative flow that I think does what you require.

It works as follows:

For a given date (e.g. 23 Feb 2024):

1. calculate the date one month later than that date
Original Date=23 Feb 2024
One month later date=23 Mar 2024

2. Note the day of month for original date (23) subtract 1 from this number (22) and then find the date that many days prior to original date. This is your First DOM.
e.g 23 Feb 2024 minus 22 days= 1 Feb 2024

3. Note the day of month for “one month later” date (23) and then find the date that many days prior to “one month later” date. This is your Last DOM
e.g. 23 Mar 2024 minus 23 days = 29 Feb 2024.

Check that this works where a 31 day month is followed by a 30 day month,…e.g. the original date is 31 May 2020

Original Date=31 May 2020, Date one month later is 30 Jun 2020
Original Date less (31 - 1) days is 1 May 2020
Date next month less 30 days is 31 May 2020

First and Last of Month.knwf (21.4 KB)

I hope that helps. I’ve continued to use the legacy nodes as these were the ones you were using, and I haven’t looked to see what the replacements/alternatives are.

Another way to achieve this might be to use a Column Expressions node, where scripts could do the entire calculation inside the one node if you are happy to hand-code it.

6 Likes

Thanks @takbb your workflow not only solved my issued but also very neat and easy to follow.

2 Likes

Hello @ali_aff

here is couple of ways you can do it with not legacy Date&Time framework (and nodes) which I advise to use in case no obstacles:

Here is workflow:
First and Last of Month_ipazin.knwf (49.4 KB)

Br,
Ivan

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.