Forum Discussion

Qrew Member

3 years ago

Error for Date(formula) field

Hello, can anyone please help me with this logic? Formula for field type: Date(forumla) If([Match]="Y",ToDate("GetFieldValues(GetRecords("{12.EX.'" & [NUM1] & "'}",[_DBID_UPLOAD]),15)"),ToDate("J...

Formulas and functions

AdityaBhandar

Qrew Member

Paul, how else I can retrieve the date from other table then?

------------------------------
Siva
------------------------------

PaulPeterson1

Qrew Assistant Captain

3 years ago

Are you certain there is a 1 to 1 relationship between the two records? If so, you could create a relationship where the Upload table is the parent and the Overrides is the child and pull the date in as a lookup. If it is not a 1 to 1 relationship, then the issue will be much more complicated.

------------------------------
Paul Peterson
------------------------------