Skip to Content
Former Member
Nov 30, 2005 at 12:00 AM

Text Variable Using User Prompt Input


I have a query that prompts the user to enter a "From Date" and "To Date" before the report is run. On the column of the report, I have a "Year to Date" heading that populates the current month/year. I want this heading populated by the "To Date" that the user entered instead of the current month/year. Does anyone know how this would work? I'm assuming I have to use a text variable but i don't see any text variables that utilizes the user entered "to date".