Datetime Function

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

Developer

Custom Tools

Custom Formula Function

Accepted answers

KrishnaChithrathil

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??

Days Left.yxmd

All comments

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?

Number of days in month.yxmd

KrishnaChithrathil

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??

Days Left.yxmd

Hi @KrishnaChithrathil

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

Hi @DataNath

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703