DATE/TIME field properties

[Childers_(Guest)]

After creating a calculated date/time field, and setting the display properties to display only the date, it displayed as expected.____However, after closing the report, and opening it again, the date/time field reverts back to a date & time composite display.______The calculated field is identical to a field in the Access table.__ ____The version is R&R SQL version 12, build 12.1.001.____

[kfleming]

I was able to reproduce this but there is a workaround.__Just add a the TODATE() function around your existing calculation and only the date part of the expression will be returned.____Kathleen__R&R Support

[Childers_(Guest)]

Ok, thanks. This project got postponed, but thanks for the response to this and the query about Joins.____