Im creating an app that will let the users pass in a date for a query to run on a database. I only want them to be able to pick the last day of the month since the data in this table is only month end data, is this possible? I know that I can let them select any date and I could then use a formula to get the last day of the moth but I really want them to only be able to select month end days
Solved! Go to Solution.
I was going to call EOMONTH in my DB query but it wont work from ALteryx, any ideas why? Its an MSSQL server and I can call that function from SQL Server studio ok
Hi @craigja
Will it satisfy your requirement to have a selection or dropdown to choose the month instead of a date?
Yeah that would be fine, how would I do that?
Hi @craigja
Created the attached for you.
Analytic app allows user to choose from a list of months.
An uppercase month value is created from the data's date field.
The data is filtered according to the chosen month.
Hope this works for you.
Please feel free to share, like and/or accept as a solution.
Thank you
Brilliant, thanks, just what I was looking for!
Thank you @craigja for liking and accepting my solution.