cancel
Showing results for 
Search instead for 
Did you mean: 

Webi Report Leap Month Issue

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (0)