Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy 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.