Computing dates from scratch is a very easy task. You usually assemble a date in the following manner:
This works as long as you run your database on a system that uses the date format MM/DD/YY. If you run your database on a system that uses the DD/MM/YY format, it will obviously cease to work properly.
To avoid this problem, you may use the following code sample:
Add to Date (!01/01/1900!; MyYear-1900; MyMonth-1; MyDay-1)