Skip to Content
0
Jun 03, 2018 at 05:01 AM

How ask for user prompt without restricting dates?

51 Views

I am trying to set up a prompt for a month end date so that I can create variables for current year, prior year, next year. I need the user to enter a prompt for date without restricting records. When I try this....

My dates are restricted from 20170101 to user prompt 'statement date'

This won't work because then I'll only get records from 20170101 to user prompt of 20180301 and then I can create variables for "next year" date 2019.

I need them to be able to enter 20180301 so I can figure out that 2017 is prior year, 2018 is current year and 2019 is next year.

Attachments

orvbs.png (18.4 kB)
f9zi5.png (13.2 kB)