Date Formatting, need some assistance

groovedrm · June 14th, 2006, 03:26 PM

Hi. I've got a pretty simple question, but didn't find exactly what I needed when looking around.

I'm trying to format a date looking like this:
09/30/2006 - 09:30:03

to something like this:
09302006093003 -but as a string.

I'm sure I could do this with string functions, but I figured there was some kind of date function that accomplished it--so far, I haven't been able to come up with something to do this.

Can anyone help?

echovue · June 14th, 2006, 04:10 PM

Try this....

Code:

dim theDate as Date

theDate = "09/30/2006 - 09:30:03"

msgbox Format(theDate, "MMDDYYYYHHMMSS")

I think that should work,

Mike

Mike
EchoVue.com

SerranoG · June 16th, 2006, 07:23 AM

Mike, I'm not so sure... in your example, theDate is a string. Therefore, for GrooveDrm to get what he/she wants (WELCOME TO P2P!), a series of LEFT, MID, and/or RIGHT function calls will have to be used with the INSTR function as well.

Your code would definitely work if theDate was truly in a date format type, but it's not.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division