Is it possible to have the date picker only allow selection of the last day in a month?

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

Interface Tools

Accepted answers

HomesickSurfer

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

choose month.png

craigja.yxzp

All comments

craigja

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