Date

[hbussell]

I want to write a report that list all clients in my database that were admitted in a given month. It does not matter which year. For example, I want all admissions for June, the year and day do not matter. My field is a date field, formatted mm/dd/yy. I have tried to convert the date field to a string, but this appears not to work. Any suggestions will be appreciated.

Thanks

 

[SmpTraining]

If your field is a date field it does not matter what formatting you have, a formula such as:

@Admitted_Month
Month (date_field)

will return the month number of the admission. Simply introduce a selection based on the @Admitted_Month field and you should see the results you're after.
Steve Phillips, Crystal Consultant