DayOfWeek

HolyAbsolut · Post by **HolyAbsolut** » Tue Feb 26, 2013 11:44 am

Hi @ all,

I'm looking for a possibility to check the Day (Monday,Tuesday,.....) for a Date which I can enter. So not like the the actual DayOfWeek who only provides Day from Today.

Who can help ?

Thanks for your effort.

Best Regards

HolyAbsolut

Post by **Marcus Tettmar** » Tue Feb 26, 2013 1:02 pm

Do you mean you want to find the day from any given date? Like this?

GetDate>thedate
VBEval>WeekDay(%thedate%,2),DayOfWeek

2 means start on Monday so a result of 1 means Monday .. 7 Sunday.

Substitute thedate for any date. Use DateLocal if you need to convert a string date to a local date stamp.

olllllliii · Post by **olllllliii** » Tue Feb 26, 2013 2:49 pm

Hi Marcus,

i am working on a ( German windows 7 ultimate 64 bit )

compiler error 1006 ')' expected...

Code: Select all

GetDate>thedate
VBEval>WeekDay(%thedate%,2),DayOfWeek

do u know what error 1006 mean ?

Post by **Marcus Tettmar** » Tue Feb 26, 2013 4:26 pm

Maybe your local date format is the problem. But I didn't think you wanted to use the current date. I thought you wanted to use some other entered date.

Well if you want to use the current date try:

VBEval>WeekDay(date(),2),DayOfWeek

CyberCitizen · Post by **CyberCitizen** » Wed Feb 27, 2013 1:04 am

Are you wanting to check the what day a future or past day is?

For Example
Question: I want to know what day it is on the 24 May 2013?
Answer: Friday

olllllliii · Post by **olllllliii** » Wed Feb 27, 2013 7:40 am

CyberCitizen wrote:Are you wanting to check the what day a future or past day is?

yes , marcus solved it ! 0=Sunday 1=Monday 2=Thuesday and so on .....

For Example
Question: I want to know what day it is on the 24 May 2013?
Answer: Friday

yes its done ...thank you ...