Change date/time field to only date field

[cutpen]

How do I change a date/time field to only a date field in the 8.5 version? I want to use the select expert on this field and be able to put only a date.

Thanks,
Penny

 

[raja2008]

use date function

 

[lbass]

In 8.5 you can go into file->report options and choose convert datetime to date.

-LB

 

[MrBillSC]

If you only want to display the date part of the date/time field you can simply change the format by placing the field on your report and right clicking. Select "format field". Then select a format that only displays the date.

MrBill

 

[cutpen]

Thank you