Weird result

[xcmav66]

Every time this code runs, it returns the number 12, regardless of the time (hour, minute, or am/pm). The same code works correctly if I replace the "mm" with "hh" or "AMPM". Can anyone help? Thanks

MinuteCombo.Value = Format(CDate(StartTimeText.Value), "mm")

 

[pbaldy]

Try "n" instead of "m", which is Month.

 

[xcmav66]

haha thank you, i'm an idiot.

 

[pbaldy]

LOL! You're not an idiot. They could just as easily have used m for minute and n for month.