GEt day of week from date string

[timle]

Hello,
How can I translate any given date to day of week
for example if 10302019 is wednesday then do something

%DayofWeek% get me today's date but I dont know how to get the back date

Thank you

[JRL]

Code: Select all

VBEval>WeekdayName(Weekday("2019-10-30",0)),vDayoftheWeek
MDL>vDayoftheWeek

[timle]

Thank you..what is the good way to learn Vb?

[JRL]

I don't know. Though in today's world and with Macro Scheduler's capabilities you'd probably be better off putting your efforts into learning Python rather than the antiquated VBScript.

I usually search for code snippets that are close to what I want then alter them to try to accomplish my goal. A lot of trial and error with no guarantee for success.

As a function reference, I like W3Schools.