How to calculated due date betwen two date in ASP.NET Web Form

Tri Setia

Hi Guys,,, I'm try to calculated due date betwen two date but I'm can't solve this trouble. I'm found the refrence code in VB and then I'm try to translate that code to C#. Anny help could be appriciate.

this isi code to calculated due date betwen two date in VB.NET

'find maturities based on installments to ??? 
DueDate.Text = DateAdd(DateInterval.Month, Val(InstallmentsTo.Text), DateValue(RentDate.Text))

and then I'm try translate that code in C#. But this code not working

//find maturities based on installments to ???private void SearchDueDate(){System.DateTime PaymentDate;System.DateTime RentDate;int InstallmentsTo;InstallmentsTo = Convert.ToInt32(txtcicilan_ke.Text);RentDate = Convert.ToDateTime(txttgl_pinjaman.Text);PaymentDate = Convert.ToDateTime(txttanggal_pembayaran.Text);DueDate.Text = Convert.ToDateTime(PaymentDate - RentDate), InstallmentsTo.ToString("yyyy/MM/dd");}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tri Setia5y ago
Problem Solved
private void ShowDueDate()
    {
        using (SqlConnection con = new SqlConnection(koneksi))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                con.Open();
                cmd.Connection = con;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = "Select tbl_pinjaman.tanggal_jatuh_tempo from tbl_pinjaman,tbl_pembayaran where tbl_pinjaman.id_pinjaman = tbl_pembayaran.id_pinjaman and tbl_pinjaman.id_pinjaman ='"+ txtid_pinjaman.Text.Trim()+"'";
                using (SqlDataReader rdr = cmd.ExecuteReader())
                {
                    while (rdr.Read())
                    {
                        txtDue_date.Text = rdr["tanggal_jatuh_tempo"].ToString();
                    }

                }
            }
        }
    }
0
Tri Setia5y ago
@Pranam Bhat
thanks for the anwers sir but I want the code using C# not in VB, because I want translate that code from VB.NET to C#.
0
Pranam Bhat5y ago
' Combine your Month and Year '
Dim monthAndYear = String.Format("{0} {1}", month.Text, yrtxt.Text)
' Parse it into a DateTime object '
Dim targetedTime = DateTime.ParseExact(monthAndYear,"MMM yyyy", Nothing)

' Using the selectd time, get the 15th day of the next month '
Dim dueDate = New DateTime(targetedTime.Year, targetedTime.Month, 15).AddMonths(1).ToString("dd-MMM-yyyy")

Demo :

https://dotnetfiddle.net/M6AjL8

https://www.c-sharpcorner.com/UploadFile/0c1bb2/duration-calculator-between-two-dates-using-Asp-Net-C-Sharp/
+1