I tried multiple ways to do this and I cannot figure out how to just get the date.
1. substring(item()?['publishDate'], 0, 10)
2. formatDateTime(coalesce(item()?['publishDate'], utcNow()), 'MM-dd-yyyy')
3. formatDateTime(item()?['publishDate'], 'MM-dd-yyyy')
PVA Return:
Yes, you are 100% correct. Thank you for your solution.
Hi @wherdzik
so RSS2 has updated date format right ?
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Ok, I see what is happening. Defiantly my error. The flow that I changed was Beckers FTE RSS. The output variable is RSS2 and I am passing it to Message box as RSS which is the wrong variable. Hmmm...Maybe I should just just create two distinct topics out of this as I don't know how to get to give me a dynamic output distinguishing between RSS and RSS2
Hi @wherdzik
When you look at run results, in the variable where you are adding the details to be posted in PVA, does that have date time format having date only or it looks same that as of in PVA ?
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Does not seem to be working.
Hi @wherdzik
3rd option which you shared would work actually, could you try this updated one ?
formatDateTime(items('Apply_to_each')?['publishDate'], 'yyyy-MM-dd')
Let me know if it works or not
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1