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!

Alteryx Designer Desktop Discussions

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

Flagging Transactions

fatimasyed
5 - Atom

Hi,

 

I would like to know (generally) how one would go about flagging transactions that occur within the last "X" days of every month.

I cannot post any workflows or screenshots due to privacy issues, thank you for understanding. 

 

Best,

FS

3 REPLIES 3
jNunez
8 - Asteroid

Check if month is different after adding X days to a value.

 

Qiu
21 - Polaris
21 - Polaris

@fatimasyed 
We can use the DateTImeTrim function to get the last day of your each date, then use DateTImeDiff to filter the date with a integer number.

0930-fatimasyed.png

caltang
17 - Castor
17 - Castor

I'm sure you can provide some sample data and also provide your expected output. It just has to closely match your problem, not the real data itself. 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels