Cindy - Looked all through the help and the 'HACK' but never looked for operators and never saw it referenced on other help pages.
I appreciate your responsiveness and help.
Thanks
Gaylen
>>>>Have 2 fields in a report - Binddate and Binddate + 30.
>
>>>
>>> Binddate + (30*24*3600)
>>>
>
>Hi Gaylen,
>
>Addition and subtraction apply to days with date data types and seconds with datetime data types.
>
>From the "Date and Time Operators" topic in Help:
>Date and Time Operators
>
>Operator Action Code
>+ Addition tNewTime = tTime1 + nSeconds
> dNewDate = dDate1 + nDays
>
>- Subtraction nSeconds = tTime1 - tTime2
> tNewTime = tTime1 - nSeconds
> dNewDate = dDate1 - nDays