Forum Discussion
sorting a date table chronologically
Is that what you want to see as result? If yes, simply add to your Date Dim couple column:Month & Year = FORMAT([Date], "MMM" & " " & "YYYY") and Sort = FORMAT([Date], "YYYYMM") ; define "Sort by Column" accordingly it will give you correct sequence.
You are a genius! Thanks so much, that worked exactly the way I wanted it.
I think that you have misunderstood. I have a date table with date, day, dayofmonth, dayofweek, month, monthofyear,ordinaldate, quarter, quarterfoyear, weekending, year. When I put the date column into the page level filter it gives me every day of every month of every year, but I only want one data point each month (my valuation date which is the last working day of each month). As an alternative I tried using Month = FORMAT([Date]; "MMM") & " " & [Year] but when that goes into the page level filter, it does not sort chronologically. I am trying to figure out how I can either remove all the dates that arenn't a valuation date in a month so that it can be used a page fillter or sort the Month column in the page level filter chronologically
Is that what you want to see as result? If yes, simply add to your Date Dim couple column:Month & Year = FORMAT([Date], "MMM" & " " & "YYYY") and Sort = FORMAT([Date], "YYYYMM") ; define "Sort by Column" accordingly it will give you correct sequence.