Need to generate report for employees based on birthday

Denis_Petrov

We are trying to create a report that would list ONLY employees born in the month of September. What filter should we use on the field "Birthday"?

thanks

Denis Petrov
#-o

Savatage

Is Birthday a Date Field?

0901..0930

{Edit - ya know I wasn't even thinking about the YEAR}
Doh! :-s

How About:
MonthName := FORMAT(Birthday,0,'<Month Text,3>');

Then you know MonthName = Jan, Feb, Mar, etc..etc

*take away the 3 for the whole name*

and you can filter on that

David_Cox

You cannot Filter on the Month unless you have a Month field, so on the report, use the CurrReport.Skip;

Use Number := DATE2DMY(Date, What);


IF DATE2DMY(WORKDATE,2)<>DATE2DMY(Birthday,2)THEN
CurrReport.SKIP;

I typed this the same time as Harry, so you have two options

Savatage

Perhaps a look at this can help too

Some Changes Needed like from Using Contacts to Employees

http://www.mibuso.com/dlinfo.asp?FileID=517

PS. How long did it take you to get business going again after Katrina.
Nice to see your OK!