import the date by chopping it up as a string before placing it into a Date Field: cvtStrDate()
once its converted into a Date Type field, then you can display the format as :dd/mm/yyyy
Code:
public function cvtStrDate( pvDateFld)
dim vDate
Code:
if isnull(pvDateFld) then exit function
y = left(pvDateFld,4)
m = mid(pvDateFld,6,2)
d = mid(pvDateFld,9,2)
h = mid(pvDateFld,12,2)
n = mid(pvDateFld,15,2)
s = right(pvDateFld,2)
vDate= m & "/" & d & "/" & y & " " & h & ":" & n & ":" & s
cvtStrDate = cvDate(vDate)
end function