Get day of the week from Date in NWC?

[mikeboggs23]

I'd like to be able to determine the day of the week from a date in NWC. Is this possible?

The Format date to string action doesn't offer ddd. 

Is it possible to use options listed here: Date and Time Format Strings - Quick Reference Guide I have no where to use a "fn-FormatDate" in NWC.

Thanks. 

[mikeboggs23]

This community needs more contributors.   

[rhia]

Joshua Tan‌ any thoughts on this one? Unsure who else I can tag here. Bingham Blalock‌??

[joshua_tan]

Hey Rhia Wieclawek‌, we've seen this request on Uservoice and added it to our backlog.

[sean_fiene · Accepted solution]

Hi Michael, 

If you have the ability to add Xtensions in your NWC tenant, I built an Xtension that will get you the day of the week from the Date value you pass through. I have the Xtenstion available here: xtensions/dayWithDate.json at master · slfiene/xtensions · GitHub 

Pass the date value through 'Body Date', the Language (which I only have 'en-US' working), and store the result in a string variable to use later in the workflow.

Thank you,

Sean

[mikeboggs23]

Just tested this, and it works great. Thank you! 

I appreciate it.