João,
>How can i know the Time in minutes from two dates, i have the datetime fields, one with 2004-06-09 12:35:58 and other with 2004-06-10 2:35:25
The others have given you the forumulas. Subtracting two datetimes gives you the difference in seconds. Subtacting two dates gives you the difference in days. You can also add/subtract integer seconds to datetimes, and add/subtract integer days to dates:
ltNow = datetime()
? ltNow + 120
ldToday = date()
? ldToday - 7
