Hey yall!
I need help figuring out how to fetch the total number of days in a month for each month in a year.
Appreciate yall!
Solved! Go to Solution.
Hi @zohairraza you can use a generate row tools to create every day between a start and end date and then you can use datetime function to extract the Month and Year and then you can summarise the data to get the total days by month and year. Have attached a workflow to showcase this. This help article is always handy to have when working with dates in Alteryx.
You can possibly use the formula to calculate this:-
DateTimeFormat(DateTimeAdd(DateTimeAdd(DateTimeTrim([Field1],"month"),1,"month"),-1,"day"),"%d")
It trims the date mentioned to the month. It then adds a month, subtracts a day, and formats the datetime string to show just the day
Hope this helps.
Best,
Jagdeesh
Youre awesome! Thank you!