Jaime - TTOD(DATE)+ 30 is a little more elegant. I was able to figure out the time portion using the TTOC function, just had trouble with incrementing the date.

Thanks

Gaylen



>Gaylen
>If you need the Date portion of a DateTime field, just use the TTOD function. In your case, you could use: TTOD( BindDate ) + 30 .
>If you need the time portion, by the way, check out the TTOC function.
>
>HTH
>Jaime
>
>
>>Have 2 fields in a report - Binddate and Binddate + 30. Binddate is Date field in table. Client now wants date and time in the report so I changed Binddate field to datetime in the table and now both field show the same date as opposed to the second field incrementing by 30 days.
>>
>>Any suggestions?
>>Gaylen