Skip to Content
Former Member
Jan 28, 2014 at 04:25 PM

Create a Group off of Date parameters


The situation is as following:

I've 4 date parameters: {?From Year}, {?From Month}, {?To Year}, {?To Month}

and the fields are {Movement_Date} and {Program}

I need to group on date for each month, and since a program could have no records for a specific month, therefore this month wouldn't be displayed if I group by {Movement_Date}

Yet the requirement is to show a group for each month wether it has records or not

Now to accomplish this I'm trying to create a date range variable off of the Date parameters in order to group on that range instead of the {Movement_Date}

The problem is that the result of the formula can't be a date range

Any inputs will be appreciative