Date Problem in Webi
I'm attempting to create a User Input variable where they would select a time range for the report output.
I'm following http://blog.davidg.com.au/2011/09/dynamic-measures-in-webi-on-any-data.html to set up radio buttons where they can select two different dates - the current date or the tenth of the month to run queries through.
I've got the radio buttons working and each selection outputs the correct date. For example, if the user selects the Radio Button called "Current Date", the dateUserInput variable outputs today's date. If the user selects "The Tenth of the Month", the date is output as 10/10/2015. I've confirmed using the IsDate formula that the outputs are read as date.
I'm attempting to run a count where the dateUserInput variable determines the end of the time period:
=Count([Sale ID] Where (([Sale Status]="CMP") And [Sale Status Date] Between([dateReportStartLastYear];ToDate([dateUserInput];"MM/dd/yyyy")));All)
but it's not working. No matter what I run with this variable, it returns 0 results. I have converted it to a date in the formula above, so I doubt that is the issue - the formula is valid in the formula editor.
If I create a simple "Current Date Variable" and replace dateUserInput with it, it works fine. What is the problem with my formula?