Show field in a different format

[medusa3604]

Hi,



I have imported data from a ORACLE database and I have a problem. I want to make a "new table query" to show related fields from 3 different tables. The problem is that the date fields is written 20150124 in the imported data and I want it to be 2015-01-24. Can I make this happen in the query design? I would write a formula something like this in the normal case: Left([Etik]![GILTIG_FRAN];4) & "-" & Mid([Etik]![GILTIG_FRAN];5;2) & "-" & Right([Etik]![GILTIG_FRAN];2)

/ Anders
Sweden

[June7]

Yes. Try it.