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 etc?
I have a simple table with customer name and contact date. I want to look at trends over time for how many customers contacted in a month, how many times a customer was contacted etc..
My date field is definitely a date field in my imported Excel worksheet formatted dd/mm/yy. Is it because I'm using Service? Do I need the desktop version? Is there something else simple I'm missing?
Many thanks.
1 Reply
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.
