Need Date to Show Day of Week

D

Dave Elliott

I have an unbound control on a form (It shows the date, i.e. 07/15/04) that
I need another control (unbound) to show it's day of the week instead of
it's value.
The unbound control that shows the whole date, not the week day is named
BeginDate. Here is it's code.
=CDate([AnyDate])-(Weekday(CDate([AnyDate])))-2
I need another control to show the same value except the day of the week
correspoding to the main control's date, i.e. BeginDate.

Thanks,

Dave
 
R

Rick Brandt

Dave Elliott said:
I have an unbound control on a form (It shows the date, i.e. 07/15/04) that
I need another control (unbound) to show it's day of the week instead of
it's value.
The unbound control that shows the whole date, not the week day is named
BeginDate. Here is it's code.
=CDate([AnyDate])-(Weekday(CDate([AnyDate])))-2
I need another control to show the same value except the day of the week
correspoding to the main control's date, i.e. BeginDate.
Click to expand...

=Format([BeginDate],"dddd")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Employees Rotate By Week? 0
Date Range Code Needed! (Thanks) 1
Need Date Code for week beginning Thursday and ending Wednesday 1
Formula to tell day of week 3
How to show day of week 4
Main form- subform for -logging hours worked for day/week 2
Can I create my own date showing day of week plus date? 2
Dteremine the day of the week based on date. 5

Top