last date / show even if blank

[AlanP]

Last ( Test History::Test Received )

In our portal (test history) there is a field for the Test Recieved (date). How can I use the above calculation to always show the last test received date EVEN if it is blank (not entry)?

Right now it will just default to the last date found in the portal records.

[aaa]

Sort portal by Test_Received_Date descending.

Your_Calculation=TestHistory::Test_Recevied_Date

Edited August 2, 2005 by Guest

[PeterHW]

That was my initial thought as well, until I tested it and found that a record with an empty date field still got sorted as the last, no matter if the sort order is ascending or descending.

So I created another field DateTest, calculation

If(IsEmpty(date);0;GetAsNumber(date))

Then sort your relationship on this new field and it should work. See attachment.

HTH,

Peter

Date.zip

[AlanP]

Hey Peter thanks! I was a little confused about that at first but it worked! I also put it as GetAsDate

If(IsEmpty(Test History::Test Received);"";GetAsDate(Test History::Test Received))

And then I sorted the relationship by test issue date descending