Show only Date not Date and Time in RTC Reports?


Hi all,
Most of the time client requires only date to be printed in the report, say for the shipment date.
But when we create the report in RTC and set the dataset field for the shipment date we get data and time.

The date in RTC Report shows date and time and that is the standard format.

If you want to show only date then we need to use the Format Property.

Example
Then in Page body click on the expression of the text box which says  “=SalesLine_ShipmentDate” and convert it to =FORMAT(SalesLine_ShipmentDate,"Short Date").

This will only show date.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/