format date stored as text to date format

[megatronixs]

Hi all,

I have a table where I run a query. the table is a linked table that comes from Oracle. There is a column with dates in it, but it is formated as text as this: 20150113. Is it possible to have this output in the query when it runs like 13/01/2015 ?

Greetings.

 

[megatronixs]

Hi all,

I found this code that I tried to use, but it comes out empty the query, and if I remove that from the query, I get data. Do I go wrong somewhere and I don't see this?

DATE: Mid([DATE],5,2) & "" & "/" & "" & Right([DATE],2) & "" & "/" & "" & Left([_DATE],4)

Greetings.

 

[Minty]

Date is a reserved name and may well be causing your problem. And you are then calling the calculated field Date as a well.

 

[megatronixs]

Hi,
I changed it to MyDate also changed the fields names it was reffering to, but still no data :-(

Greetings.

 

[arnelgp]

format it as date:

CDate(Format([date], "0000/00/00"))

 

[megatronixs]

Hi,

I will try this one first thing tomorrow

Thanks and greetings.