Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Minimum and Maximum Date

Status
Not open for further replies.

moonknightt

Programmer
May 7, 2002
92
US
Cystal reports 10. Crystal enterprise 10

I have a date range formula in my Crystal reports
ToText (Minimum ({?DateRange}))
+ " To " + ToText (Maximum ({?DateRange}))

This works fine.

if I select a minimum date greater than the maximum it gives me as Alert to change the date. But this is not so in crystal enterprise. It allows you to but a date range like
10/31/2002 to 10/15/2002. is there any solution to this or an alert that can be created

thanks
Moon
 
I'd put in a warning section that is suppressed except when minimum exceeds maximum.

[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 

thanks MADAWC,

Crystal Enterprise reverses the dates but it doesn't include the end value which is now the start value or vice versa even though the "Include value" tab is checked
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top