General information
Category:
Coding, syntax & commands
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only