Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to limit the data pulled into a pivot table to only data with a date greater than today. The first Expression below works by itself.
Expression 1)
=count({<[Visit Start Date]={">=$(=Today())"}>}1)
When I add the URL expression to the Pivot Table -it also brings in data prior to today - based on the date selection on the page, but I only want data in this table >=Today.
Expression 2)
=if([Visit Start Date]>=$(=Today()),'Link to Form <url>'&FormURL,0)
Thank you for any help you can offer.
May be this is what you are looking for
=if([Visit Start Date]>=Today(), 'Link to Form <url>'&FormURL, 0)
what about
concat({<[Visit Start Date]={">=$(=Today())"}>}'Link to Form <url>'&FormURL)
May be this is what you are looking for
=if([Visit Start Date]>=Today(), 'Link to Form <url>'&FormURL, 0)
what about
concat({<[Visit Start Date]={">=$(=Today())"}>}'Link to Form <url>'&FormURL)