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

Date Range Code Needed! (Thanks) 1
Need Date Code for week beginning Thursday and ending Wednesday 1
Refer to Sub-form and input Date? 1
Date Problem Help Needed, Please 14
convert date to julian date 4
BeginDate and EndDate to return the 1st & last day of current mont 1
Dteremine the day of the week based on date. 5
Date Difference Code Help Needed! 2

Top