Returning Visit information between a month

[JamesMF82]

Hi,

I have a selectable dimension called CalanderMonth that I am able to select return information for the current month of shifts that have not been allocated. This works fine, but I would like to be able to return the following months information.

I have a VisitStartDate field that I am using for the date element, a new variable which works out the following month start and one that works out the end of the month vNextCalendarMonthStart and vNextCalendarMonthEnd respectively.

Currently I have the formula =num(Sum({<VisitPayStatus = {'Incomplete*'}}VisitCounter) ,'#,###.') to pull the data for this month, but I need to expand it to only return information on the following month. Any help would be great. Thank you.

[abhijitnalekar]

Hi @JamesMF82 ,

Please try the below expression.

num(Sum({<VisitPayStatus = {'Incomplete*'},

VisitStartDate=("='>=' & Date(vNextCalendarMonthStart, 'MM/DD/YYYY') & '<=' & Date(vNextCalendarMonthEnd, 'MM/DD/YYYY')")

>}VisitCounter) ,'#,###.')