ProfileAccount.zip
Hi all,
Trying to figure out a query or multiple queries that will provide me with a Next Deposit Date. This same thing
will be used in different forms but just this for now till I get some type of solution. Maybe someone has something
I can use to get started?
So, db attached, opens to Form1 which is the form with the controls on it. I programed the controls for the
most part and will tweak code once complete. What I have not done is the Next Deposit Date...
On Deposit Frequency section,
the Select has 5 options in the combo which is a Value List
1;"Weekly";2;"Monthly";3;"Bi-Monthly";4;"Annually";5;"Semi-Annually"
Then it has FirstDay, SecondDay, FirstMonth, SecondMonth Fields
So, what I would like to do is:
If Select "Weekly" No Next Deposit Date Period! Just leave Enabled = False
If Select "Monthly" and FirstDay is not null, then create a date one month or 30 days in advance from that day.
Basically if Today is 07/11/2022, and my FirstDay # is 15, then then My NextDepsoitDate would be 15/11/2022. If
Today was 25/11/2022 and FirstDay # is 15, then my NextDepsotDay would be 15/12/2022 and so on....
If Select "Bi-Monthly and FirstDay and SecondDay are not Null, then create a date that is one month or 30 days from that
day. If Today is => SecondDay then use that Field "FirstDay" # as the day or If Today is >= FirstDay then use
the Field "SecondDay" # as the day
Basically if My FirstDay was the 15 and My SecondDay was the 31, then If today was between the 31st and the 14th, then it would show the
Next Depsoit Day being the 15th, If today was between the 15th and the 30th, then it would show my Next Deposit Day the 31st.
If Select "Annually" and FirstDay and FirstMonth are not Null, Then Create a date that is on year from those two fields
, one being a day and one being a month.
So, If I select Annually, and my FirstDay is the 7th and the Month is 11 and if today is
11/12/2022 then my Next Deposit Date would be 7/11/2023
If Select "Semi-Annually" and FirstDay, FirstMonth, SecondDay, SecondMonth were not Null, then create a date! If Today
>= FirstDay, FirstMonth but <= SecondDay, SecondMonth then the SecondDay,SecondMonth Fields would be used to creat
a Next Deposit Date and If Today >=SecondDay, SecondMonth but <= FirstDay, FirstMonth then the FirstDay,FirstMonth Fields would
be used to create Next Deposit Date.
If Today is 7/11/22, and my FirstDay Is 6, First Month is 3, and my SecondDay is 6, And the SecondMonth is 9, then
My Next Deposit Date would be 06/09/22
Questions on the following:
What I am not real sure about is how that will react if a month has less then 31 days????????
Thanks
Dave