Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 tackle different date formats being entered by user in Supporting Reference in BIP Report?

in Subledger Accounting & Accounting Hub 2 comments

Summary:

I have a scenario when users input dates in multiple formats eg.18/Mar/2022, 18/March/2022, 18/03/2022, 2022/03/18 while posting a Journal in the Supporting References.

Also users tend to enter wrong date formats and date gets in the xla table as junk value.

How to avoid the report getting erroring out?

Issue arises when we query the Supporting Reference data in a BIP Report.

Have someone experienced the same issue?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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