Forum Discussion
Working with dates
My apologies for what is probably a really basic question, but I must be missing something simple! Is there a reason why I can't make my date format to dd/mm/yy and filter and sort by year, month...
Try the little drop down arrow for Backup Date in your fields area, you may be able to switch it to the Date Hierarchy instead of the actual date. Otherwise, you may need desktop and add in a YEAR and MONTH columns using those functions.