I have a situation wherein I need to get the date from the user for my report ( Date Prompt).
I do create a date prompt and make the sure to supply the date for the report.
Based on the date supplied by the user I need to have filter conditions like
Transaction Process Date Between ( First Day of the month of the Report Date Prompt) and ( Last Day of tne month of the report date prompt ) .
How would I achieve this as I need to make the filter based on the report date prompt value supplied ( formulating the first day and last day of the month of the report date prompt).