pabbly can check the number of days in a specific month?

[rodrigo]

Hi,

With Pabbly Connect is it possible to identify the current month and create a result that shows how many days there are in this month? Example:

January
Result: 31

February
Result: 28

March
Result: 31

April
Result: 30

These number are offcourse the number of the days in the current month!

I'm thinking of creating a workflow to extend the subscription of my customers licenses and this will help!

 

[PabblyMember4]

Hey @rodrigo

Kindly allow us a day's time to check the scenario. You can use any spreadsheet formula to achieve this scenario or if you are fetching the data then you can use the LookUp function and can fetch the data through it.

 

[rodrigo]

Hey @Kunal Valuskar did you found a solution?

Thanks

 

[Pabblymember11]

You can refer to the following screenshot regarding your concern.

DAY(EOMONTH('MM/DD/YYYY',0))