Skip to Content

Webi Report Leap Month Issue

Feb 23, 2017 at 05:35 PM


avatar image
Former Member


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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers