ToText(minimum(AllDatestoToday)) + ' to ' + ToText(maximum(AllDatesto

[JoyCR9]

ToText(minimum(AllDatestoToday)) + ' to ' + ToText(maximum(AllDatestotoday))

I am using the above formula to convert dates to text. The output I get is:

-47 13-01-01 to 2005-01-24

How do I get the firstdate that a record is used vs the first date in my DB?

Crystal Reports 9. SQL and Oracle 8.

 

[lupins46]

The earliest date in the table is just
Minimum({mytable.mydatefield})

I don't know what you mean by the 'first date a record is used'.

 

[JoyCR9]

Let's assume my database's first date is Jan 01, 2000. However in the report I'm running the record selection criteria hits a match on April 01, 2004.

By first date used I mean April 01, 2004 not Jan 01, 2000.

Sorry for the confusion. Thanks for posting.

 

[lbass]

I get a meaningless result when I try using a minimum on that function also. If you have no record selection criteria, you could use:

minimum({table.date})

If you want the minimum within a certain time frame, then add a record selection criterion like:

{table.date} >= date(2001,01,01)

And then use the above formula.

-LB

 

[JoyCR9]

Thanks. I will put in a minimum. I was hoping to have an open start date so that I wouldn't miss any historical data.

LastFullMonth works great for month to month data with my formula. I was hoping that AllDatesToToday would do the same. Oh well.