Hellow there!!
I have a table with field name Sdate (Short date dd-mm-yyyy)
In the same table i have another field I_Months (Numeric field)
now what i want that if i select todays date i.e. 12 Dec 2019 and select 6 in I_Months field means i want 6 rows to added in new table with month name like this as SDate would be the first start month (Its a installment DB)
Dec 2019 1
Jan 2020 2
so on till
May 2020 6
Any help would be appreciated
I have a table with field name Sdate (Short date dd-mm-yyyy)
In the same table i have another field I_Months (Numeric field)
now what i want that if i select todays date i.e. 12 Dec 2019 and select 6 in I_Months field means i want 6 rows to added in new table with month name like this as SDate would be the first start month (Its a installment DB)
Dec 2019 1
Jan 2020 2
so on till
May 2020 6
Any help would be appreciated