Displaying Month data from a Parameter

[rwn]

I'm starting with this forumla:
Month ({@TransDate}) = Month ({?Pm-?EndDate}).

But what is desired: when a user enters in a Date in {?Pm-?EndDate}) ONLY the values in the @TransDate(this formula converts a datetime to a date) that are within the Month of the date entered are displayed.

For example: if a date of 3/31/2010 is entered then all the dates for the 3/31/2010 to 3/1/2010 are shown; if a date of 3/15/2010 is entered than all the dates from 3/15/2010 to 3/1/2010 are shown for 3/2010. I hope this makes sense.

 

[briangriffin]

This selection formula should do what I think you're looking for:

{@TranDate} in date(year({?EndDate),month({?EndDate),1) to {?EndDate}