Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #296: Breaking News - Headlines and Keywords

snbandi
8 - Asteroid

My solution.

 

If I use DateTimeFormat(Left([pub_date],10),"%A") to get DOW, I get the answer. However if first the Date by DateTimeParse with "%Y-%m-%d %H:%M-%S %z", the DOW is different. My understanding is we are supposed to be using the total Timestamp when supplied rather than just parsing through Date alone.

SGolnik
11 - Bolide
11 - Bolide

I may come back and take on the bonus!

asultanov
8 - Asteroid
Spoiler
Screenshot 2024-01-24 150118.png
christopher_ontkean
8 - Asteroid

Solution.