If the date format is DD/MM/YYYY, use the following expression using field calculator in a new field (LONG)
Int (Right( [Date], 4 ) & Mid( [Date], 4, 2 ) & Left( [Date], 2 ) )
If the date format is DD/MM/YY, use the following expression using field calculator in a new field (LONG)
Int (Right( [Date], 2 ) & Mid( [Date], 4, 2 ) & Left( [Date], 2 ) )
Think Location