Stimulsoft Business Intelligence System | Forum

Posted: **Fri Oct 13, 2017 4:25 pm**

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)}

Posted: **Sun Oct 15, 2017 8:04 am**

Hello.

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}

Please, check the the type of the Day_5_Date_First column is Datetime.
Thank you.

Posted: **Wed Oct 25, 2017 2:04 pm**

Worked thanks

Posted: **Thu Oct 26, 2017 2:45 pm**

Great! You are welcome!

Stimulsoft Business Intelligence System | Forum

If formula using today

If formula using today

Re: If formula using today

Re: If formula using today

Re: If formula using today