Try
Binddate + (30*24*3600)
MartinJ
>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