>Can anybody tell how I can extract the date and time from a datetime field. For example I have a record which in the created field states: 17/02/2006 09:57:42 AM.
>
>I would like to store 17/02/2006 to a variable and 09:57:42 to another variable
>
>Any help would greatly appreciated
Date=TTOD(datetime)
Time=TIME(datetime)