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?

edited Apr 5, 2022 9:34AM in Reporting and Analytics for ERP 2 comments

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?

Howdy, Stranger!

Log In

To view full details, sign in.


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