Date filter values used as a parameter for stored procedure

Daniel Stankovic shared this question 10 months ago
Answered

I have a question about using date filter values in a procedure. More particularly, I would like to be able to choose some date range from a filter (e.g. 10/20/2018-10/24/2018), and pass that range as a parameter to find how many business days are in that range (I can use a stored procedure to find that), and use this value the procedure returns (3 in this case) for further calculations. Is there a way to achieve this? I hope I explained my problem well. Thank you in advance.

Comments (2)

photo
1

Hi Daniel,

Thanks for reaching out with your question. In the case of dates, there is not a way to use a user-defined filter as a parameter in Yellowfin unfortunately. Date difference calculations are done at the database level, as such filtering will not affect the values or format. Hopefully this answers your question.


Thanks,

Eric

photo
1

Hello Eric, Thank you for the reply. I will try to find some way around it then.

photo