Originally Posted by
orcinus
Yes, its in a query,
However, not sure if that would work without using 2 fields.
As I see it, if I split up the data using right/left functions, I can concatenate the data back, but would be left with a text field again. I am trying to get a date AND time field not a text field..
Access tables have both the date/time option. Is there perhaps a function that includes this as well?
You know, I'm not really sure what the future is like for fields that are simply converted using built in resources. To be absolutely sure that the field is essentially date/time data type without question, I'd make a new table from the qry and see what data type comes out of it.
as for the syntax, you want something similar to the formatting of the Now() function I assume. So why not try:
Code:
cdate(format(
left(field, instr(field, " ") - 1) & " " & right(field, instrrev(field, " ") - 1)
, "general date"))
and see what happens? I'm sure this is over complex, but until someone offers something else, you might be stuck with me.
<edit>
I just noticed you're on 03, so you might have to substitute the following in for the instrrev() part:
Code:
((len(field) - instr(field, " ")) - 1)