Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table
Dep_Date | Dep_Month |
2/1/2019 | Feb,2019 |
4/3/2019 | April,2019 |
9/7/2019 | September,2019 |
11/7/2018 | Nov,2018 |
I have a Slider Chart , based on the Dep_Month , however the months are not sorted in order of DATE. Its displaying the months in alphabetical order.
I am using below expession in the sort
=date(date#([dep_month], 'MMM-YYYY'), 'YYYY-MM-DD')
Note: db_month was pupolated by Alteryx DateTimeformat() function
what is the issue? and what is your expected output?
as i understand your slider is showing more than 4 Month dates( your source table Dev_Month is having only 4 months)
if my assumption is correct
=Date#([Dep_Month], 'MMM-YYYY')
what is the issue? and what is your expected output?
as i understand your slider is showing more than 4 Month dates( your source table Dev_Month is having only 4 months)
if my assumption is correct
=Date#([Dep_Month], 'MMM-YYYY')