Skip to main content
Solved

Use date field from filter form


Blommetje
Forum|alt.badge.img+13

Hi,

I have a filter form with a date field. 

Is this date available for me to do some calculations with? 

So in this case I want to have 5/1/2021, so that I can use this to calculate the amount of days before the date of the search. 

Is this possible?  

Thanks! 

Alex 

 

 

 

 

 

Best answer by Mark Jongeling

Hi Alex,

That is not possible. The filter form will only filter the existing rows but the value itself cannot be used for expressions. The value you've entered in the filter form should then be a value in the database so the expression/calculated column can use that value to show the right number.

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3945 replies
  • Answer
  • May 20, 2021

Hi Alex,

That is not possible. The filter form will only filter the existing rows but the value itself cannot be used for expressions. The value you've entered in the filter form should then be a value in the database so the expression/calculated column can use that value to show the right number.


Blommetje
Forum|alt.badge.img+13
  • Author
  • Partner
  • 209 replies
  • May 20, 2021

Thanks for the quickanswer @Mark Jongeling 

I will try and solve this another way. 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings