Different Format date LOV after migrated report
I have migrated report from BO 6.1.3 to BO XI 3.1 SP3.
Report has migrated but i have one issue like:
The date format is different for lov of Report in 6.1.3 and XI 3.1 SP3, even when I recreate the prompt
Old Report 6.1.3 before migration 'dd/mm/yyyy'
Old Report 6.1.3 after migration on XI 3.1 SP3 'mm/dd/yyyy'
New Report XI 3.1 SP3 'dd/mm/yyyy'
and when I run the query the data is incorrect.
Please let me know how we can resolve this issue....