VBA Error

[reggiete]

Hello All,

the below code for some reason does not work correctly.

Private Sub Form_Load()
If Me.Remediation_Start_Date.Value = Me.Target_Response_Date.Value Then
Aged_Loan.Value = "No"
ElseIf Me.Remediation_Start_Date.Value >= Me.Target_Response_Date.Value Then
Aged_Loan.Value = "Yes"
MsgBox "The Targeted response date has passed, Loan is now Aged.", vbOKOnly Or vbExclamation, "Remediation Review Alert - Aged Loan, Please review target completion date"

What i am basically needing to happen is when the Remediation Start Date is > Target Response date it place "Yes" is the Aged Loan field.

If the Remediation Start Date = Target Response Date, then Aged Loan Value = "No"

But for some reason when the start date = target response date it still places the Yes in the aged loan text field.

 

[pbaldy]

Are you sure your fields don't include a time value?