Is it possible to have the date picker only allow selection of the last day in a month?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Interface Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @craigja
Will it satisfy your requirement to have a selection or dropdown to choose the month instead of a date?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yeah that would be fine, how would I do that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Brilliant, thanks, just what I was looking for!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @craigja for liking and accepting my solution.
