Required Date prompt returns no data

[actcognosuser]

Date prompt is set to required. When the report is run it is allowing the user to select the Finish button even if the date was not selected.
 UI is Edit Box

[MFGF]

Date prompt is set to required. When the report is run it is allowing the user to select the Finish button even if the date was not selected.
 UI is Edit Box

Things to check:
Is there a default set for the prompt - either in the Default Selections property, or if the prompt is driven from a macro in an expression, within the prompt macro?
Is the Usage of the filter the prompt ties to set to be required or optional?

Cheers!

MF.

[actcognosuser]

There is no default set on the date prompt.

This is a required filter in the query



[ReportDate]>=to_char(?P_StartDate?,'Mon DD, YYYY')
and
[ReportDate]<=to_char(?P_EndDate?,'Mon DD, YYYY')

Also by pulling the paramdisplayvalue(?P_StartDate?) and ?P_EndDate? , I noticed
that the calendar date is displaying as May 1, 2024 instead of May01, 2024.