Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx IO Discussions

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.
SOLVED

Datetime Function

AS
8 - Asteroid

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 monthNumber of day in S month
02-06-202029
02-01-202130
04-08-201918
01-02-202128

 

Thanks in Advance :)

7 REPLIES 7
AS
8 - Asteroid

Hi Could you please help. @atcodedog05 

DataNath
17 - Castor

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

 

DataNath_0-1667209717255.png

 

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
11 - Bolide

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

 

KrishnaChithrathil_0-1667209369037.png

 

AS
8 - Asteroid

Hi @KrishnaChithrathil  

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

AS
8 - Asteroid

Hi @DataNath 

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

atcodedog05
22 - Nova
22 - Nova

Hi @AS 

 

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

 

atcodedog05_1-1667295970396.png

 

 

Hope this helps : )

AS
8 - Asteroid

No worries and Thanks for the proper explanation.