Assigning new date values when using IFF() function

[evflores001]

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)

[Lech Kulikowski]

Hello,

Where do you want to change datetime value - in the data source or in the Text component?
If in the text, you can use the following expression
{IIF(LoanCredits.Loan_Credits.LoanName=="10th Pl - 6803", "10/31/2020", LoanCredits.Investments_Credits.EndDate.Date)}

Thank you.

[evflores001]

Thank you!

Sorry for the delayed repsonse.

[Lech Kulikowski]

Hello,

You are welcome.