Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Fiscal Month Grouping

mwilhite25
5 - Atom
‎10-10-2022 11:10 AM

I have a data set were there is an order create data for each record. I need to group the order create dates into date ranges that match a fiscal month calendar. The issue I am running into is that the fiscal month ends after the last Saturday of every month, making it somewhat of an ever-changing grouping. I am aware of formulas such as this: DateTimeMonth((DateTimeAdd([Order Create Date],-5,"days")), however this will produce a stagnate date range grouping for me. Anyone have any ideas?  

Labels:
Reply
2 REPLIES 2
Felipe_Ribeir0
16 - Nebula
‎10-10-2022 11:19 AM

Hi @mwilhite25 

 

if i understood well, if you knew the date of the last saturday of each month, you could go ahead and solve it all, right? 

 

Felipe_Ribeir0_0-1665425921429.png

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

 

Thanks.

 

LastSaturday.yxmd
Reply
0 Likes
binuacs
21 - Polaris
‎10-10-2022 03:04 PM

@mwilhite25 Can you provide some sample data and expected output result?

Reply
Labels