Page 1 of 1
DATE/TIME field properties
Posted: Sun Jul 20, 2008 10:06 am
by 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.____
=> RE: DATE/TIME field properties
Posted: Mon Jul 21, 2008 10:13 am
by 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
==> RE: DATE/TIME field properties
Posted: Wed Aug 06, 2008 11:36 am
by Childers_(Guest)
Ok, thanks. This project got postponed, but thanks for the response to this and the query about Joins.____