We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Date based expressions showing as text fields

Received Response
23
Views
1
Comments
edited Jun 8, 2016 6:00PM in Reporting and Analytics (TBE) 1 comment

Content

I've created a report for a client which has pivot tables in it. I am grouping results by month and then week.

I have used the following expression to display the month from the interview date: DATE_FORMAT([REQU|REQU-REQU_CAND|REQU_CAND-INTV|date], "MMMM")

The problem I'm facing now is that the resulting expression field is a text field, so when I try to sort the column to show the months in order, it is displaying them in alphabetic order. For example, the report for the last two months displays as April, June, May

Has anyone else encountered an issue like this? I'm open to suggestions...

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!