>In a table I have a date() not datetime() type
>
>I want to get it into a variable and transform to datetime
>
>Then I need to start at 0 hour to do the operations
>
>example
>
>oginal field: 01/01/2009
>
>I need to transform it in 01/01/2009 00:00
>
>It there an easy way to to it, rather than adding "0000" to the final of the date expression?

dtot(date) will create a datetime field with 00:00.