Day from date..

[mshelley1]

Access 2000:

Text1= Date
Text2= Weekday

Is it possible, using code, to convert the date in textbox1 to the corresponding weekday and place that value in text2?

 

[ZanyJanie]

Here's a simple little function that demonstrates converting a date into it's weekday name.

Hope this helps!

-----------------

Function WeekdayFromDate()

varDate = InputBox("Enter a date:")

varWeekdayNum = DatePart("w", varDate)

varWeekdayName = WeekdayName(varWeekdayNum)

MsgBox (varDate & " is on " & varWeekdayName)

End Function

 

[Rich]

You don't need any code, just set the display format for the field to "dddd"