I am trying to pull the latest date from the ChgLog for a specific field and it is not working 100%.
In the SSRS report, I used the expression:
=iif(Len(First(Fields!DateStampedOn.Value, “ChgLog”)) > 0,
"Last Revision: " & Last(Fields!DateStampedOn.Value, “ChgLog”),
It works most of the time but after extended use, I am told it is not 100%.
How would I go about sorting the field so it can pull the last one?
Any help is greatly appreciated.