I need a formula to use in Sel Exp to show full curr month data 1

[eo]

Hi

CE10

I need a function that works similar to LastFullMonth. But it must be used in Select Expert and show data for the Current Full Month. Runable at any point during the month.
I.e. something that calculates the first and last days of the month, and run the report for that period.

Anyone know how?



EO
Hertfordshire, England

 

[GJParker]

Try

{MyTable.DateFiled} >= Date (Year(today),Month(Today) ,01 ) and{MYTable.DateField} < Date (Year(today),Month(Today)+1 ,01 )

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[dgillz]

First, don't use the select expert, there are way too many limitations there. Use a record selection formula instead.

Second try a formula like this:

{MyDateField} in MonthtoDate

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[eo]

Thanks for the advise re the Select Expert formula. Can however not use MonthtoDate, coz that will limit the no of records to the CurrentDate. Not include the rest of the month (still to come). Gary's formula worked a treat.
Thanks

EO
Hertfordshire, England