Format a date

[SAC]

I'm getting data from another computer and the dates are like this:

20050622

Do I have to parse the string and then put it back together or is there a
better was to handle it?

Thanks.

 

[Rick Brandt]

I'm getting data from another computer and the dates are like this:

20050622

Do I have to parse the string and then put it back together or is
there a better was to handle it?

Thanks.

I would use...

DateSerial(Left(YourField, 4), Mid(YourField, 5, 2), Right(YourField, 2))

 

[SAC]

WOW! Thanks! Works beautifully!

I would use...

DateSerial(Left(YourField, 4), Mid(YourField, 5, 2), Right(YourField, 2))