Assigning new date values when using IFF() function
Posted: Wed Dec 02, 2020 9:35 pm
Hello,
I am trying to parse through a column with date values and returning and reassigning a date value to a specified date. I only want to change the date value of a specific loan if the name matches the loan. The following is what I have, though I have been readjusting the IFF statement in attempt to get it functioning
IIF((LoanCredits.Loan_Credits.LoanName=="10th Pl - 6803"),LoanCredits.Investments_Credits.EndDate.Date==10/31/2020,LoanCredits.Investments_Credits.EndDate.Date)
I am trying to parse through a column with date values and returning and reassigning a date value to a specified date. I only want to change the date value of a specific loan if the name matches the loan. The following is what I have, though I have been readjusting the IFF statement in attempt to get it functioning
IIF((LoanCredits.Loan_Credits.LoanName=="10th Pl - 6803"),LoanCredits.Investments_Credits.EndDate.Date==10/31/2020,LoanCredits.Investments_Credits.EndDate.Date)