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
edited Dec 14, 2022 6:44AM in Taleo Business Edition (TBE) 1 comment


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.


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