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