We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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