Maximo Open Forum

 View Only

 European vs. American date format causing BIRT report to fail

  • Reporting
Jeffery Murray's profile image
Jeffery Murray posted 11-01-2023 13:42

We have a Multi-Org set up; one org for Spanish /European clients and one for US clients. The European date format switches the day and month compared to US format. We have a BIRT report that uses a date range to pull work order information. The report fails because it is looking for the dates to be in US format. Since the users running the report are in Spain and their profile uses the European format which causes the report error out.

Currently the only solution I have found is to temporarily change the user profile for the person running the report to the US format. Any suggestions or solutions would be appreciated.

Norma Ramey's profile image
Norma Ramey posted 11-02-2023 12:29

In the Inialize() for the .rptdesign handle the date coming into the report.  Look at the OOB woprint.rptdesign as an example of creating the function to query the database. 

You could grab the base language from the user login to Maximo.  Use the Language table, l_synonymdomain, to grab LANGCODE.

~~Norma

Related Content