SOLVED
Flagging Transactions
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
fatimasyed
5 - Atom
‎09-29-2023
01:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
3 REPLIES 3
jNunez
8 - Asteroid
‎09-29-2023
01:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Check if month is different after adding X days to a value.
21 - Polaris
‎09-29-2023
06:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
17 - Castor
‎09-29-2023
07:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
![](/skins/images/1A7F54316481E10DBCA4A87A32E06CC6/responsive_peak/images/icon_anonymous_message.png)