In a report I have the following expression:
=DLookUp("[fieldName]","tableName")
Where fieldName is a long date field.

However if I do:
=DLookUp("[fieldName]","tableName") & "."
It adds the full stop like it should but the date format keeps changing to short. How can I fix this?