Minimum

[bld21]

I am using crystal reports 2008. I am using a formula to parse out a date field.

right({@usps 3},10)

I want to be able to see the oldest dates. I am trying to use "Minimum" to show the earliest date. I can't quite get it to work with the "Right".

Any ideas?
Thanks!

 

[briangriffin]

I would suggest that you convert the field to a real date prior to doing the minimum - something like:

date(right({@usus 3},10)

This probably won't work as is - the format needs to be:

date(yyyy,mm,dd)

So you might have to do:

date(right({@usus 3},4) + "," + left({@usus 3},2) + "," + mid({@usus 3},3,2))

You get the idea. Once you have the formula returning a true date value then the minimum should work as expected.

 

[bld21]

Thanks Brian!