can^t save display format change for date-time fields
can^t save display format change for date-time fields
Ver 12.5. I^m using a date time as report filter because R&R won^t let you use a date against a date-time field in the database. I also want to display the date on the report, but only as a date, not a date time. When I place the date on the report, it shows it in date-time format. I open the properties window and uncheck the "show time" box. The field then shows as a date in designer and on a preview report. I open the report in the viewer and it has gone back to date-time. I open the report again in designer and it too has gone back to date-time, so it appears that the display format change is not being saved.____I know i can create another calc field in the proper format and place it on the report but that^s a bit of a pain.____Any ideas out there?____
=> RE: can^t save display format change for date-time fields
Have you tried the ToDate() function? It takes the datetime, strips off the time and treats the field as a date only.____However, we *are* going to fix this behavior in a future release.
Chris Strasser
Liveware Publishing, Inc.
Work bigger.
Liveware Publishing, Inc.
Work bigger.
==> RE: can^t save display format change for date-time fields
Thanks for the reply. BTW, this only appears to be a problem in page headers, not in group or record lines.__