If formula using today

Jump to: Board indexAll-in-OneStimulsoft Reports.Ultimate

Stimulsoft Reports.Ultimate discussion

If formula using today

Post 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)}
laducd
 
Posts: 111
Joined: Thu Oct 23, 2014 2:15 pm

Re: If formula using today

Post 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.
HighAley
 
Posts: 7510
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: If formula using today

Post Wed Oct 25, 2017 2:04 pm

Worked thanks
laducd
 
Posts: 111
Joined: Thu Oct 23, 2014 2:15 pm

Re: If formula using today

Post Thu Oct 26, 2017 2:45 pm

Great! You are welcome!
Andrew
 
Posts: 3689
Joined: Fri Jun 09, 2006 3:58 am


Return to Stimulsoft Reports.Ultimate

Who is online

Users browsing this forum: No registered users and 2 guests

cron