Good evening, I'm having a little trouble with returning a day in a day of week field. I didn't want to enter a dropdown list to pick a day, I wanted it to be automatic from the date entered. I've entered my date in one field and I want to return the"day of week" in another field but can't seem to get it to work. I can get it to work in a query but can't get it to work in my subform. Am I missing a step? I'm creating a daily construction report and need it to return the day of week. Is there anyone out there that can help me...PLEASE Thanks T
On 20/03/2008 in message Building Buildings wrote: >Good evening, >I'm having a little trouble with returning a day in a day of week field. I >didn't want to enter a dropdown list to pick a day, I wanted it to be >automatic from the date entered. I've entered my date in one field and I >want to return the"day of week" in another field but can't seem to get it >to >work. I can get it to work in a query but can't get it to work in my >subform. Am I missing a step? If you have a DateTime called dtCurrent (set to the date you are interested in) then: dtCurrent.DOW.ToString(); should do it, I had to do that yesterday, can't look it up, HD is being re-formatted ATM! -- Jeff Gaines
