Retrieve Day Number From Day Name

[DMT Dave]

Hi Guy's, how do you get a day number from a day name ?

I have a combo (cboDay) set as Value List Monday;Tuesday;Wednesday;Thursday;Friday

I have a field called DayNo Set as Number

When i select Wednesday, how do i set it to auto add 4 to DayNo (Sunday being Day 1 system day of the week)

Thank you

[Bob Fitz]

Try the Weekday() function.

[CJ_London]

Set your combo value list to 2;Monday;3;Tuesday;4;Wednesday;5;Thursday;6;Friday

change the column count to 2 and column width to 0 (which will hide the first column)

[DMT Dave]

Well thought of, it's the simplest of things that are typically hard to do