Desktop productivity for business analysts and programmers

Null able date range in a filter

Reply
Occasional Contributor
Posts: 5

Null able date range in a filter

I have a query in EG with a filter based on a Date Range prompt.  It all worked fine until the users said they didn’t want to make the date range mandatory.  So in the prompt I turned off the option.

“Require a non-blank value”

But when I run the report with blank dates I’m getting the following error.

FROM WORK.BUILD_UAT_IMP t1 LEFT JOIN WORK.MAX_IMP_DATE t2 ON (t1.IMP_REQ_ID_CHR = t2.RPD_REQ_ID_CHR) LEFT JOIN

43                   WORK.MIN_IMP_DATE t3 ON (t1.IMP_REQ_ID_CHR = t3.RPD_REQ_ID_CHR)

44               WHERE %_eg_WhereParam( t2.LatestPlannedDate, Prompt_Dates, BETWEEN, TYPE=D );

ERROR: Invalid date/time/datetime constant ""d.

ERROR: Invalid date/time/datetime constant ""d.

I’m fairy new to SAS so apologies if this has been covered elsewhere.

Any help would be much appreciated.

Ask a Question
Discussion stats
  • 0 replies
  • 144 views
  • 0 likes
  • 1 in conversation