Posted: Thu May 24, 2012 6:02 pm
Exactly what I meant when I said "Inline Field() functions" and then described what to do first and second. Thanks James, although I was hoping Kiran would be able to work this out on his own...jwiles wrote:So, to get the date from a particular pair within the record:
The inner Field() call returns the pair--such as BBB|5/24/11--then the outer Field() call returns the date from that pair--5/24/11.Code: Select all
Field(Field(record,",",pair_number),"|",2)