-
1. Re: Problem creating a Start and End Dates filter using Parameters
Deepak RaiJul 13, 2018 3:06 PM (in response to Anjali Sn)
You Convert Your Date To First Day of Month Like this and Create Parameter using that New Date
Your New Date
DATE(DATETRUNC('month', YOUR ACTUAL DATE))
This will always default to First Day of Month, Right Click on It and Create Parameter or when you Create Parameter , use From Field>Your New Date
Thanks
Deepak
-
2. Re: Problem creating a Start and End Dates filter using Parameters
Anjali Sn Jul 13, 2018 3:37 PM (in response to Deepak Rai)I don't understand. Like I said my date field only has first day of the months only.
-
3. Re: Problem creating a Start and End Dates filter using Parameters
Deepak RaiJul 13, 2018 3:39 PM (in response to Anjali Sn)
So from where you are getting 11/5/2017 then?
-
4. Re: Problem creating a Start and End Dates filter using Parameters
Anjali Sn Jul 13, 2018 3:56 PM (in response to Deepak Rai)No idea. So I have a Month field coming from the data source which is of string data type and 'YYYY-MM' format. I am converting it into a date field called [Date] like this:
date(right(str([Month]),2) +"/1/" + left(str([Month]),4))
Next I create the Start Date and End Date parameters using this Date field. Then I create a Date Range filter as follows: [Date] >= [Start Date] AND [Date] <= [End Date]
Now when I select the start date as Jan 2018 and end date as Jun 2018, I only get data from Feb 2018 to June 2018, and similarly for selecting other start dates as well.
-
5. Re: Problem creating a Start and End Dates filter using Parameters
Deepak RaiJul 13, 2018 3:59 PM (in response to Anjali Sn)
Try This To Create Date from your String First
MAKEDATE(LEFT(MONTH Field,4),RIGHT(Month Field,2),01)
-
6. Re: Problem creating a Start and End Dates filter using Parameters
Anjali Sn Jul 13, 2018 4:02 PM (in response to Deepak Rai)Getting Unknown function MAKEDATE
-
7. Re: Problem creating a Start and End Dates filter using Parameters
Deepak RaiJul 13, 2018 4:04 PM (in response to Anjali Sn)
Looks like you are on Live Connection, did you try DATEPARSE?
-
8. Re: Problem creating a Start and End Dates filter using Parameters
Anjali Sn Jul 13, 2018 4:07 PM (in response to Deepak Rai)So, I see that when in the Start Date parameter I select "List" in "Allowable Values", it works fine. But when I select "Range", it gives this problem. Anyway to make this slider work??
-
9. Re: Problem creating a Start and End Dates filter using Parameters
Deepak RaiJul 13, 2018 4:10 PM (in response to Anjali Sn)
-
10. Re: Problem creating a Start and End Dates filter using Parameters
Anjali Sn Jul 13, 2018 4:12 PM (in response to Deepak Rai)I am doing that only but it doesn't do anything
-
11. Re: Problem creating a Start and End Dates filter using Parameters
Deepak RaiJul 13, 2018 4:13 PM (in response to Anjali Sn)
It is difficult to Help without a workbook which I suppose you can't attach...
-
12. Re: Problem creating a Start and End Dates filter using Parameters
Anjali Sn Jul 13, 2018 4:30 PM (in response to Anjali Sn)Don't know what the problem was but I did like that (the correct ans I selected) using my [Date] field and it worked!
-
13. Re: Problem creating a Start and End Dates filter using Parameters
Deepak RaiJul 13, 2018 4:33 PM (in response to Anjali Sn)
Wow!!! That was the Logic actually