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

Look Back
How to verify and validate correct date formats in OTBI where the column is supporting references. — 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

How to verify and validate correct date formats in OTBI where the column is supporting references.

Accepted answer
1
Views
1
Comments
in General Transactional Reporting (OTBI) 1 comment

Summary:

We have a scenario where we are using a supporting reference column and casting it as date.

But due to multiple formats of date being entered in the column with different date formats,the report errors out.


Code Snippet (add any code snippets that support your topic, if applicable):

CAST(CASE WHEN "Supporting References Without Balances"."Supporting Reference Name 31" = 'Payment Due Date' THEN "Supporting References Without Balances"."Supporting Reference Value 31" WHEN "Supporting References Without Balances"."Supporting Reference Name 32" = 'Payment Due Date' THEN "Supporting References Without Balances"."Supporting Reference Value 32" WHEN "Supporting References Without Balances"."Supporting Reference Name 33" = 'Payment Due Date' THEN "Supporting References Without Balances"."Supporting Reference Value 33" WHEN "Supporting References Without Balances"."Supporting Reference Name 34" = 'Payment Due Date' THEN "Supporting References Without Balances"."Supporting Reference Value 34" WHEN "Supporting References Without Balances"."Supporting Reference Name 35" = 'Payment Due Date' THEN "Supporting References Without Balances"."Supporting Reference Value 35"

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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