DLookUp changes date to txt? 1

[GaborH]

Is these something simple that I am overlooking?

I have DLookUp function working correctly in a Make tbl query; however, the data type on the resulting table changes from date to txt. I have tried to set the querey format via "format(DLookup(...),"dd/mm/yyyy") and made sure that field properties in the query are set to date, but to no avail.

Any hints highly appreciated.

GaborH

 

[gol4]

have you attempted the conversion function cdate()

cdate(dlookup(....))