Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to sort date fields customized by expressions
Summary
Need to reformat date fields customized by an expression in order to sort the data in chronological order, by month.Content
Using the TBE Reporting Tips & Tricks Vol. 1 doc, I created an expression to customize a date field. I wanted to include only the year and month in which candidates applied to a req.
Here's my expression:
| YEAR([REQU|REQU-REQU_CAND|dateApplied]) + "-" + MONTH([REQU|REQU-REQU_CAND|dateApplied]) |
For any candidates who applied in March 2018, it would display as 2018-3 (April = 2018-4, etc). I used this to create a line graph showing the # of candidates who applied in each month.
Tagged:
0