Todatetime can be used if you need to transfer date, month, year, hour, minute and seconds to a single field in the destination.
Example:
You need to transfer all the above fields sDay,sMonth,SYear,sHour,sMinute,sSecond into one Datetimefield.
sDay=15
sMonth=05
sYear=2009sHour = 12
sMinute= 44
sSecond= 23
##TODATETIME("sDay","sMonth","sYear","sHour","sMinute","sSecond")
Returns the value = 20090515 12:44:23 as a datetime.
If that format does not match the date in the destination Data Base, you can add a FORMAT formula:
##FORMAT(TODATETIME("sDay","sMonth","sYear","sHour","sMinute","sSecond"),'%d-%m-y%:H%.M.%S')
Returns the value 2009-05-15:12.44.23