convert to date

[referee]

hi ,

i want i a query a convert to a date

i have the following

2005011

year/weeknumber/daynumber


now i want a expresion in my query to have this result

1/01/2005


can someone halp me please

thanks

 

[maxmangion]

=Format([fieldname], "dd/mm/yyyy")

 

[referee]

thanks for reply;

i have as result this

12/07/7389 for 2005011

and it want to be 1/1/2005

do i something wrong

with this Op: Format([DTPLAN];"dd/mm/yyyy")

 

[maxmangion]

if DTPLAN is the name of your field, then it should be

=Format([DTPLAN], "dd/mm/yyyy")