how to i write a code for get the day of the date where i enter date but i want to know which day is that.
example, i enter 29/06/2001 then i can gee the day is FRIDAY.
Regards,
Wilson Chai
Printable View
how to i write a code for get the day of the date where i enter date but i want to know which day is that.
example, i enter 29/06/2001 then i can gee the day is FRIDAY.
Regards,
Wilson Chai
WeekDay = Format(YourDate, "dddd")
Hello Wilson:
You can this code:
days = Format(Text2.Text, "dddd") 'dddd will give you day
Text1.Text = days
Good Luck
Please send back a reply
Thank you
days = Format(Text2.Text, "dddd") 'dddd will give you day
Text1.Text = days
dddd is what day is that ? sunday... or is given set by us and not by system
Regards,
Wilson Chai
Format(Text2.Text, "dddd", vbMonday)
but if you not set 3 parameter, used system default
Hello:
Text2.text is your input and 'dddd' is the format that translate Text2.text into the day you want. For example, if you put into Text2.text: 25/06/2001, you will get Monday.
I hope this answers your question.
Robert Moy