Skip to main content
Question

Error for Date(formula) field

  • January 5, 2022
  • 0 replies
  • 63 views
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

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
------------------------------
Siva
This topic has been closed for replies.

One issue I'm seeing is that your query can return more than one value and the ToDate function is only designed to work with one value.  If you are certain the query will only return 1 date, you could create a variable and us that in the ToDate function.

var date = dateQuery = GetFieldValues(GetRecords("{12.EX.'" & [NUM1] & "'}",[_DBID_UPLOAD]),15)

If([Match]="Y",ToDate($dateQuery),ToDate("Jan 30, 2000"))​


------------------------------
Paul Peterson
------------------------------
Terms & ConditionsAccessibility statement