Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Convert Date Field — 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

Convert Date Field

Accepted answer
25
Views
2
Comments
edited Nov 12, 2019 9:44PM in General Transactional Reporting (OTBI) 2 comments

Summary

Convert from MM/DD/YYYY to YYYY-Qx

Content

Hello,

I have a date field I want to convert. 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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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