Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
KellyK
Contributor
Contributor

Pivot Table - limit data to only TODAY's date and forward - Expressions include a Count & a URL

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.

@sunny_talwar

Labels (2)
2 Solutions

Accepted Solutions
sunny_talwar

May be this is what you are looking for

=if([Visit Start Date]>=Today(), 'Link to Form <url>'&FormURL, 0)

View solution in original post

pradosh_thakur
Master II
Master II

what about 

 

concat({<[Visit Start Date]={">=$(=Today())"}>}'Link to Form <url>'&FormURL)

Learning never stops.

View solution in original post

2 Replies
sunny_talwar

May be this is what you are looking for

=if([Visit Start Date]>=Today(), 'Link to Form <url>'&FormURL, 0)
pradosh_thakur
Master II
Master II

what about 

 

concat({<[Visit Start Date]={">=$(=Today())"}>}'Link to Form <url>'&FormURL)

Learning never stops.