R5 - Extracting the last 8 characters in a date field??

[JoseQuiervo]

I have a field that allows more than one date to be entered in the form. Then I have a view trying to calculate the difference between that field and another date field. Example: ReportDate minus TestDate (TestDate being the date with multiple dates)

How can I set the view up to have the ReportDate minus just the last 8 characters of the TestDate?

Thanks in advance for the help.

 

[pmonett]

If I understand correctly, you want the difference between the Report Date and the last value of the multiple value TestDate.
To get the last element of a list field, you just need to use @Implode and grab the last part, like this :

@RightBack(@Implode(listValues;"~");"~")

Of course, this assumes that the list is text.

Pascal.