Get Number of Days In Month Action Out Put Not Coming.

[KodiSrihari]

Hi Team,

I want to get the No of days in a particular month, but i can't able to get the Number of Days in the Output.

I am providing the Input Month & Year in below format and output data item created as Number.

I have tried the providing the Month as text Like : Jan, January, JANUARY. But no output.

Please suggest if i need to give the input in other format ?

Thanks,

Srihari

[Mohamad_747]

Hi @KodiSrihari 

Please follow these steps :  

1 - Bring a dataitem with type text name it Date

2 - Bring a dataitem with type number name it nb days

3 - Bring a calculation stage and put this inside it : 

DateDiff(9,
ToDate("1/"&FormatDate([Date],"MM/yyyy"))
,
DateAdd(5, 1, FormatDate([Date],"MM/yyyy"))
)

And store it in bn days like this : 

Your flow should look like this :

If it work for you please mark best answer

[Mohamad_747]

Please notice that you can provid the input in this format MMM-YYYY example (Jan-2024)

You can provide also the input with this format MMMM/YYYY (JANUARY/2024)