Need Date to Show Day of Week

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
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
 
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")
 
Back
Top