Datetime Function

[AS]

Hi Experts,

I got stuck in a date time function and need your guidance. There is a formula in excel EOMONTH. I'm unable to replicate this in Alteryx. The functions working on "Number of day in S Month" =EOMONTH([@[S month]],0)-[@[S month]]+1

S month	Number of day in S month
02-06-2020	29
02-01-2021	30
04-08-2019	18
01-02-2021	28

Thanks in Advance :)

[AS]

Hi Could you please help. @atcodedog05 

[DataNath]

@AS if you just want to measure the number of days in a month you could do something like so:

However, there looks to be a bit more here? Are you able to explain the logic of what's going on in the ([@[S month]],0)-[@[S month]]+1 part?

[KrishnaChithrathil · Accepted solution]

Hey @AS !

I believe Number of day in S Month column is equal to the number of days left in that month.

Is this something you want??

[AS]

Hi @KrishnaChithrathil  

yes you are right. Thank you so much for the help

[AS]

Hi @DataNath 

Thanks for the reply. Column values are different than yours. I really appreciate your help. 😊

[atcodedog05]

Hi @AS 

Sorry for the delayed response I am not active as before😅. Here is my take on it with explanation of each step.

Hope this helps : )

[AS]

No worries and Thanks for the proper explanation.