I would like to use today in my IIF formula, basically saying IF today is > then the date coming from my report, give me one value, if not give me another. I am returning no value below.
{IIF(today()>Dates_for_Header.Day_5_Date_First,Closing_Balance.Day_5_Closing_Balance_Sum,Closing_Balance.Day_4_Closing_Balance_Sum)}
If formula using today
Re: If formula using today
Hello.
Please, try to use next expression:
Please, check the the type of the Day_5_Date_First column is Datetime.
Thank you.
Please, try to use next expression:
Code: Select all
{Today>Dates_for_Header.Day_5_Date_First?Closing_Balance.Day_5_Closing_Balance_Sum:Closing_Balance.Day_4_Closing_Balance_Sum}
Thank you.
Re: If formula using today
Worked thanks
Re: If formula using today
Great! You are welcome!