AnvikaReddy
7 years agoQrew Trainee
My Requirement:
I have Two Tables (ParentCompany & Child Company)
ParentCompany fields are:
Company Name,Start Date,End Date,HC
Child Company fields are:
fullmonth,cMonth,cHC
When i Click new parent companey button (Means adding new record) and select values like below
Company Name:Anvika solutions
Start Date:01/05/2018(mm/dd/yyyy)
End Date:06/15/2018(mm/dd/yyyy)
HC:1
I want to final requirent is like below
Then click save button insert records
ParentCompany fields are:
Company Name,Start Date,End Date,HC
Anvika solutions,01/05/2018,06/05/2018,1
Child Company fields are:
fullmonth,cMonth,cHC
No,Jan,0.8(beacause start date is not full month it means selected date start with 5th)
Yes,Feb,1(beacause full month),
Yes,march,1(beacause full month)
Yes,april,1(beacause full month)
Yes,may,1(beacause full month)
No,Jun,0.5(beacause end date is not full month it means selected date start with 15th)
Advance Thanks,
Anvika
ParentCompany fields are:
Company Name,Start Date,End Date,HC
Child Company fields are:
fullmonth,cMonth,cHC
When i Click new parent companey button (Means adding new record) and select values like below
Company Name:Anvika solutions
Start Date:01/05/2018(mm/dd/yyyy)
End Date:06/15/2018(mm/dd/yyyy)
HC:1
I want to final requirent is like below
Then click save button insert records
ParentCompany fields are:
Company Name,Start Date,End Date,HC
Anvika solutions,01/05/2018,06/05/2018,1
Child Company fields are:
fullmonth,cMonth,cHC
No,Jan,0.8(beacause start date is not full month it means selected date start with 5th)
Yes,Feb,1(beacause full month),
Yes,march,1(beacause full month)
Yes,april,1(beacause full month)
Yes,may,1(beacause full month)
No,Jun,0.5(beacause end date is not full month it means selected date start with 15th)
Advance Thanks,
Anvika