Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
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
Start Free Trial

Alteryx Designer Desktop Discussions

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

Required last Posting date on the basis of month

Maheshp
8 - Asteroid
Thursday

Hi Team,

 

I have two pstng dates in the output file (08/01/2025 & 08/31/2025) but i want only last day of the month, some month would be 30. so how can i put the Filter.

 

Pstng DateDoc. DateEntry DateDocumentNo
08/01/202508/31/202508/29/202556000106
08/01/202508/31/202508/29/202556000106
08/01/202508/31/202508/29/202556000106
08/01/202508/31/202508/29/202556000106
08/31/202508/31/202508/29/202556000106
08/31/202508/31/202508/29/202556000106
08/31/202508/31/202508/29/202556000106

 

Regards,

Mahesh

Preview file
12 KB
Labels:
Reply
0 Likes
2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor
Thursday

Hi @Maheshp you can use the formula DateTimeTrim using the arguement lastofmonth. Your date field will need to be ISO format e.g YYYY-MM-DD to utlise this formula within a filter for example.

 

Screenshot 2025-09-25 105136.png

Lastofmonth_25092025.yxmd
Reply
dreldrel
8 - Asteroid
Thursday

You can also use DateTimeDiff to minus 1 day from the start date of the month

Reply
0 Likes
Copilot AMA
License admin COmmunity Live
Labels
Top Solution Authors
View All