Forum Discussion
Issue with DistinctCount and displaying count
I have a table that lists ticket_number as the primary key, each with a unique number. Each ticket has a date_opened and a date_closed value. Those valuses are DATE format. I wanted to have a bar cha...
Those valuses are DATE format. Doesn't look like it. Maybe the display format is Date but the column format is DateTime. Use DATEVALUE() to strip away the time part.