You are viewing limited content. For full access, please sign in.

Question

Question

Invalid Date Format [Workflow] 9.1.0.328

asked on February 5, 2015

 I need to know what the syntax is for using Tokens or CustomQuery>ResultsFound within the Search Repository function.

I keep getting error "Invalid Date Format. [9161]" when running the workflow.

Here's the Search Syntax with explicit dates that works, but have been unable to use formatted Tokens or formatted CustomQuery>ResultsFound output:

{LF:LOOKIN="March-Vision-Care-DEV\Provider Services"} & {[]:[Clean_UnClean]="U"} & {[]:[EntityType]="IND"} & {LF:name="DISCL -*", Type="DFS"} & {[]:[Date Signed]>"1/22/2015", <="2/2/2015"}

Things I've tried:

  1. Using SQL output as a String or Date and formatting the CustomQuery>Results Found with and without quotes
  2. Initializing Tokens and modifying them after the Custom Query with and without formatting and with and without the quotes in the Search Syntax

 

Here's the Workflow without Tokens

0 0

Answer

SELECTED ANSWER
replied on February 5, 2015

Never mind... I named my SQL output column and it's working like a charm now

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.