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

[craigja]

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

[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

[HomesickSurfer]

Hi @craigja 

Will it satisfy your requirement to have a selection or dropdown to choose the month instead of a date?

[craigja]

Yeah that would be fine, how would I do that?

[HomesickSurfer]

Hi @craigja 

I will put something together and reply.

[HomesickSurfer · Accepted solution]

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

[craigja]

Brilliant, thanks, just what I was looking for!

[HomesickSurfer]

Thank you @craigja for liking and accepting my solution.