AdityaBhandar
3 years agoQrew Member
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("Jan 30, 2000"))
Error: Expecting Datetime/workdate but found textlist
------------------------------
Siva
------------------------------
Formula for field type: Date(forumla)
If([Match]="Y",ToDate("GetFieldValues(GetRecords("{12.EX.'" & [NUM1] & "'}",[_DBID_UPLOAD]),15)"),ToDate("Jan 30, 2000"))
Error: Expecting Datetime/workdate but found textlist
I am trying to say, if field Match="Y", then use date from UPLOAD table by matching NUM1 in details with NUM1 in Overrides.
Field ID 15 in table: UPLOAD is date.
------------------------------
Siva
------------------------------