Salary Process

lina11

I want to display a message in pay slip and the condition is if the employee's date of birth is on the next month of the salary process......will any one tell me how can i do this???????

mohana_cse06

You have to tell us what you have tried to achieve your requirement..

lina11

suppose an employees birthday is on 12/12/55 and the salary is process in the month of November (11) then a message will display in the pay slip happy birthday in advance.

mohana_cse06

i understood your requirement..i need to know what you tried to achieve this and what problem you are facing..

this forum is not to provide solutions to your requirements..it is to solve the problems which you are facing while solving..

lina11

date:=Employee."Birth Date";
day := DATE2DMY(date,1);
month1 := DATE2DMY(date,2);
year1 := DATE2DMY(date,3);
IF (month1=MonthList) THEN
txt:='Wishing You Happy Birthday In Advance';

I wrote this but the problem i am facing that is after giving the month in the option june then in the report the message display for all employee.........
month list is a option field
and month1 is the extracted month from the dob of employee

mohana_cse06

I tried this code in Form - OnAfterGetRecord() and working

IF "Birth Date" <> 0D THEN
  IF DATE2DMY(CALCDATE('<-1M>',"Birth Date"),2) = DATE2DMY(TODAY,2) THEN
    MESSAGE('Advanced Happy Birthday.');

lina11

i also tried this but this is not working............

mohana_cse06

You should be more clear on not working..

Where did you try this?

lina11

i tried this on the employee on after get record ().on the time of running i give the employee no and choose the month=june in the request form....but the output remain same.....

mohana_cse06

lina11 wrote:

i tried this on the employee on after get record ().on the time of running i give the employee no and choose the month=june in the request form....but the output remain same.....

ahhhhh ](*,) ](*,) ](*,)

It wont give you expected result in report..

If you keep on pressing next button in Employee Card..Message will be shown on the employee code whose b'day is on next month(on the form itself not on report)..

So similar logic should be used in Report.

Albertvh

[b]txt := '';[/b]
date:=Employee."Birth Date";
day := DATE2DMY(date,1);
month1 := DATE2DMY(date,2);
year1 := DATE2DMY(date,3);
IF (month1=MonthList) THEN
  txt:='Wishing You Happy Birthday In Advance';

Clear the Txt variable before testing.