find name of the Day from the Date selected

[aman]

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

 

[Isskint]

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.

 

[gemma-the-husky]

or format(thedate,"dddd")

 

[aman]

Thanks. It worked perfectly fine.