date function

[sjpritch]

Okay i have a userform that staff will be inputing Name in first textbox, date in 2nd text, etc.
I'm trying to figure out a way to force the date to show just month and day. For instance
User types date as
04102015
I would want it to show 04/10

User types
4-10-15
I would still want it to show 04/10

I think there might be to many variables to deal with. But i'm unsure.

[6StringJazzer]

Dealing with free-form user date input can get complicated. You would be better off using two combo boxes with a list of months and a list of days to pick from. Then you don't have to parse user input and you don't have to reformat dates. The user never even gets a chance to enter a year.

[sjpritch]

I didn't even think of that. Thanks

[6StringJazzer]

Here's sample code. You still have to check to see if it forms a valid date (i.e., can't allow April 31, can't allow February 29 unless it's a leap year).

Please Login or Register  to view this content.