Help Current Month Records Only

[Monkeyboy126]

Hi

I have a report that contains Helpdesk records and each has an open date and a closed date.

I have a requirement to display only call that have been opened during the current month. I currently use an initial parameter field to select a date range but want this to be automatic.

Any ideas??

thanks

 

[Naith]

Like: {OpenDate} >= Date(Year(CurrentDate),Month(CurrentDate),1)

Naith

 

[Monkeyboy126]

Naith

Sorry lame question but where would this line go?

Thanks

 

[Reebo99]

Or :

{OpenDate} in MonthToDate

This needs to be in the Record Selection Formula

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.