Page 1 of 1

Assigning new date values when using IFF() function

Posted: Wed Dec 02, 2020 9:35 pm
by 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)

Re: Assigning new date values when using IFF() function

Posted: Sat Dec 05, 2020 9:09 am
by 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.

Re: Assigning new date values when using IFF() function

Posted: Tue Dec 29, 2020 5:38 pm
by evflores001
Thank you!

Sorry for the delayed repsonse.

Re: Assigning new date values when using IFF() function

Posted: Wed Dec 30, 2020 7:44 am
by Lech Kulikowski
Hello,

You are welcome.