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