Solved

Use date field from filter form

Blommetje
Userlevel 5
Badge +12

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 

 

 

 

 

 

icon

Best answer by Mark Jongeling 20 May 2021, 15:26

View original

2 replies

Mark Jongeling
Rank
Userlevel 7
Badge +23

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
Userlevel 5
Badge +12

Thanks for the quickanswer @Mark Jongeling 

I will try and solve this another way. 

 

Reply


Terms & ConditionsCookie settings