Hello
I was asked to make a change in the code
I am currently calculating how much a student should pay per day
where [extday] is the calculation of how many days the student was present in the month by the Diff2Dates function What they asked me now that from 01.04.2024 to 15.04.2024 is a full charge of a month and from 16.04.2024 to 31.04.2024 is half a charge of the month my code
The question is how do I make the rule in the code apply to the following months and the following years because according to the code it is limited to 04.2024
I was asked to make a change in the code
I am currently calculating how much a student should pay per day
Code:
=IIf(IsNull([Form]![extday]),"0",[amount]/30*[Form]![extday])
Code:
=IIf([startdate] Between #01/04/2024# And #15/04/2024#,[amount],IIf([startdate] Between #16/04/2024# And #31/04/2024#,[amount]/2,[amount]/30*[extday]))