RSS Feed Format date from 2024-02-29 16:12:15Z to 2024-02-29 without time

(0) Share

Report

Posted on by wherdzik

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:

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Thanks & Regards,
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! 🙌

Was this reply helpful? Yes No
wherdzik on at

Like (0)

Report
Copy link

Link copied!

Does not seem to be working.

formatDateTime(items('Apply_to_each')?['publishDate'], 'yyyy-MM-dd')

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Thanks & Regards,
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! 🙌

Was this reply helpful? Yes No
wherdzik on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @wherdzik

so RSS2 has updated date format right ?

Thanks & Regards,
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! 🙌

Was this reply helpful? Yes No
wherdzik on at

Like (1)

Report
Copy link

Link copied!

Yes, you are 100% correct. Thank you for your solution.

Was this reply helpful? Yes No