on 02-23-2017 5:35 PM
Hi,
Webi Report has prompts for start date and End dates.
Report that shows sales for the selected month and previous year same Month. So, when I run the report for Feb’2016, I am getting leap year issue, as I am using variables for: Current Year’s selected Month Date Range: =MonthNumberOfYear([v_Prompt Begin Date])+"/"+DayNumberOfYear([v_Prompt Begin Date])+"/"+Year([v_Prompt Begin Date]) Previous Month Date Range: =MonthNumberOfYear([v_Prompt End Date])+"/"+DayNumberOfYear([v_Prompt End Date])+"/"+Year([v_Prompt End Date]) Could you please help?
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.