find name of the Day from the Date selected

aman

Registered User.
Local time
Yesterday, 19:33
Joined
Oct 16, 2008
Messages
1,251
Hi All

I want to find out the day of the week from the Date selected in a textbox.
e.g if I select 05/05/2016 then the day "Thursday" should come
up in another textbox.

Can anyone please help me in this?

Thanks
 
Hi Aman

You want to use the Weekday() function.

One way to implement this would be to use the AfterUpdate event of the selection textbox. use Weekday() to determine the day number of the date, then use a select case to set the other textbox to the day name.
 
or format(thedate,"dddd")
 
Thanks. It worked perfectly fine.
 

Users who are viewing this thread

Back
Top Bottom