(CR ver 10)
I have 2 lines with 3 fields, but i have to compare id14 to id3 lines to get a comparevalue field (want to show whether admission date is >,< or = to completedate).
ID Desc datevalue
3 admissiondate 5/7/07
14 completeddate 6/1/07
I would like to show up on one line using some sort of formulaI have the @when formula created, just cant get them on one line)
admissiondate completeddate {@when}
5/7/07 6/1/07 before_admit
I have 2 lines with 3 fields, but i have to compare id14 to id3 lines to get a comparevalue field (want to show whether admission date is >,< or = to completedate).
ID Desc datevalue
3 admissiondate 5/7/07
14 completeddate 6/1/07
I would like to show up on one line using some sort of formulaI have the @when formula created, just cant get them on one line)
admissiondate completeddate {@when}
5/7/07 6/1/07 before_admit