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!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Help in data logic

MadhavTR
8 - Asteroid

I have Period (date) in a column which is of pattern 2025/003, 2024/009 (YYYY/0MM). I need to manipulate this data into the last day of that particular month, for example if 2025/003 then 31/03/2025 and so on. 

 

Need your help in the solution. TIA

4 REPLIES 4
binuacs
21 - Polaris

@MadhavTR 

DateTimeFormat(DateTimeTrim(DateTimePArse([Date],'%Y/0%m'),'LastofMonth'),'%d/%m/%Y')

 

image.png

MadhavTR
8 - Asteroid

Thank you it worked.

MadhavTR
8 - Asteroid

I have got 1 more variation now, how do I find out the exact same expression for 6 months prior. For example in certain use case if period = 2025/003 i need to get it as 30/09/2024 instead of 31/03/2025

binuacs
21 - Polaris

@MadhavTR Try the below formula

DateTimeFormat(DateTimeAdd(DateTimeTrim(DateTimePArse([Date],'%Y/0%m'),'LastofMonth'),-6,'month'),'%d/%m/%Y')

 

 

image.png

Labels
Top Solution Authors