Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Expected Close date as Quarter and Year — Cloud Customer Connect
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

Expected Close date as Quarter and Year

Received Response
22
Views
1
Comments
edited Nov 12, 2019 9:42PM in Reporting & Analytics for Sales 1 comment

Summary

How can I show the Expected Close Date as a Quarter and Year?

Content

Hello,

Our Opportunities have an expected close date. I want to convert that from MM/DD/YYY to "YYYY-Qx". Any thoughts on how to do this? I've tried using the Calendar functions in the formula. They work, but don't get me the exact above format. I have to use two separate columns. One gets the quarter number so, in the example above, it would just say "1". The other column I'm able to get the year "2020". When I try do a Concat in the 3rd column, I get syntax error b/c I think it doesn't like to concatenate formulas apparently. Any help would

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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