Skip to main content
Answer

Use date field from filter form

  • May 20, 2021
  • 2 replies
  • 82 views
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.

This topic has been closed for replies.

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Mark Jongeling
  • Administrator
  • 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.

"Wake me up before you low-code"
Blommetje
Forum|alt.badge.img+13
  • Blommetje
  • Author
  • Partner
  • May 20, 2021

Thanks for the quickanswer @Mark Jongeling 

I will try and solve this another way. 

 

Terms & ConditionsCookie settingsAccessibility statement