Date Range

[EscapeUK]

I have a date range para. and i would like the dates chosen to be displayed on the report

 

[kenhamady]

See the faq on common formulas.
There is an entry for parameters created using the 'range' option. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[EscapeUK]

Thats great but...

It returns the date and time because that is what the user selects however i would like it only to display the date

 

[EscapeUK]

Think i sorted it myself

I convert the dates using....

DateValue (( Minimum ( {?Date} ) ) )

and

DateValue (( Maximum ( {?Date} ) ) ) ...in formulas

then in another formula i used

"From: " + ToText ({@DatePartingFrom} ) +
" To: " + ToText ({@DatePartingTo} )


It works but is there a better way

 

[kenhamady]

If you don't need the times anywhere in the report, you can use Crystal's Automatic "Convert DateTime to Date" option, which reads all datetime fields in the report as dates.

Change this for one report under:
File - Report Options. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal