Hi,
i've been trying to convert a date format like dd/mm/yy to a SAP used format like dd.mm.yyyy .
a simple string conversion like
is not working, the year is converted wrong.
thus 17-07-62 should be converted to 17.7.1962 ( european date format )
Please help.
Thanks in advance.
Erwin
i've been trying to convert a date format like dd/mm/yy to a SAP used format like dd.mm.yyyy .
a simple string conversion like
Code:
pp = day(datefield) & "." & month(datefield) & "." & format(year(datefield),"YYYY")
thus 17-07-62 should be converted to 17.7.1962 ( european date format )
Please help.
Thanks in advance.
Erwin