The function Todate can be used if you want to transfer date, month and year to a single field in the destination.
Example:
Source holds day, month and year in separate fields which needs to be transferred into a Date field in the destination:
sDay=15
sMonth=05
sYear=2009
##TODATE("sDay","sMonth","sYear")
Returns the value = 15-05-2009.
If that format does not match date in the destination Data Base you can add a FORMAT formula:
##FORMAT(TODATE"sDay","sMonth","sYear"),'%Y%m%d')
Returns the value = 20090515.
If you need a specific separator you can add that in the formula:
##FORMAT(TODATE("sDay","sMonth","sYear"),'%Y-%m-%d')
Returns the value = 2009-05-15.
You can have year into digits (o3) by using y instead of Y:
##FORMAT(TODATE("sDay","sMonth","sYear"),'%y-%m-%d')
Returns the value: 09-05-15