Salut,

Tu peux essayer :

SELECT CDate(Right(date_num,2) & "/" & Mid(date_num,5,2) & "/" & Left(date_num,4)) AS date_fr
FROM table;