convert a string to time formatting

[Guest]

I'm having trouble converting #### string to a date/time formatted field.
I'm looking for a hh:nn result.

If I change the table format from text to date/time I get "#error" results.
other conversions yield 0000 in the field.

 

[Joseph Meehan]

I'm having trouble converting #### string to a date/time formatted
field. I'm looking for a hh:nn result.

If I change the table format from text to date/time I get "#error"
results. other conversions yield 0000 in the field.

How about posting some of the data, just the years, you are trying to
convert.

I don't think Access will know what a four character string is in terms
of date. DDMM? MMYY? YYYY etc.?

 

[John Vinson]

I'm having trouble converting #### string to a date/time formatted field.
I'm looking for a hh:nn result.

If I change the table format from text to date/time I get "#error" results.
other conversions yield 0000 in the field.

Try:

TimeValue(Val(Left([timestring], 2)), Val(Mid([timestring], 3, 2))

John W. Vinson[MVP]