Get First and Last day of the month

How to get the first and last day ex.( sept 01) and (sept 30) 2021. Thank you

Here’s a possible solution:

  1. Create a list of numbers and fill this list with the number of days for each month, from January to December. Ex: daysInMonth= [31, 28, 31, 30, 31, 30, 31, 31…]
  2. From your date variable get the month component formatted in number and store the retuned month number in a variable; monthNumber=GET_DATETIME_COMPONENT("2012-07-11T13:06:15+03:00", "month")
  3. Now get the last day of the month by indexing from the list in step 1: daysInMonth[monthNumber-1]. Note that you have to subtract 1 from monthNumber as AppGyver indexing starts at 0 and not at 1.

As for the first day, it’s always going to be 01.

Thank you sir @Alan_Alves for response. i solved this today. and use this JS code
image