Return Day of Week Constant

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to be able to take a date field and convert it to a day value. For
example I would like to input 9/14/06 on a form field (Cmb_Work_Date) and
display "Thursday" in another field (Cmb_Work_Day_of_Week).

Thank you in advance for any and all input.
 
Format(Me.Cmb_Work_Date, "dddd")

If you're inputting the value in Cmb_Work_Date, put that in the AfterUpdate
event. If you're getting values for Cmb_Work_Date from the form's recordset,
you'll also want it in the form's Current event.
 
Back
Top