Script for the last day of the month

Questions
1

Hi everyone, could you please kindly help me on this?

  1. is there any script to take the last day of the month?
    For example in below picture, current month is Jun. So i want day will be 30. if Feb, output is 28, or output is 31 for Mar
    image
    image2064×828 25.3 KB
  2. In case the last date of the month is on Sat or Sun, is there any script to set the last date of the month on working day (Mon-Fri) only.
2

Check it out:

Be aware that you need to add the following env variable:
- NODE_FUNCTION_ALLOW_EXTERNAL=moment

Warm,
Simon

1 Like
3

thanks a lot for your guideline.
Could you guide me more where i should put the Fuction2 node in this workflow

image
image1089×311 10.6 KB

4

Share your WF I’ll edit it for you,
You should add it before the node where you gonna to use it and bind it via expression :wink:

5

For simplicity sake I’d suggest using the inbuilt Luxon library that ships with more recent n8n versions. This avoids importing functions with NODE_FUNCTION_ALLOW_EXTERNAL.

To get the last day of the month you could use this in an expression
{{ $today.set({ day: 1 }).plus({ months: 1 }).minus({days: 1}).toISODate() }}

2 Likes
6

@pemontto thks a lot. how can i change it to this format
image

your current output is like this

image
image1689×820 24.5 KB

and if the last day is on weekends, How can i set up so that it move to Fri? the format i need just MM/DD/YYYY?

7

how can i do this like you?

image
image1105×567 16.7 KB

8

Hi @H_nh_Nguy_n, you can format dates by replacing .toISODate() with .toFormat('L/d/yyyy'). Check out this list for all tokens you can use in .toFormat().

To preview a workflow simply select and copy your workflow from the n8n canvas and then paste it here on the forum using the preformatted text option on a new empty line:

image
image766×322 16.5 KB

9

Thanks a lot for your support!! i can change the format now

10

@MutedJam Could you help me if the last day is on weekends, How can i set up so that it move to Fri? the format i need just MM/DD/YYYY?

11

Here’s a verbose function that should show you how it can be done: