Dates appearing in American format

building reports desktopintelligence
1

Hi, I’m sure this is probably me missing something straightforward but I’d be really grateful if anyone can help - for the last couple of weeks, when I retrieve data from the database into a Desktop Intelligence report, all the dates are appearing in American format and I have to manually format the cells to get them to appear as dd/mm/yyyy rather than mm/dd/yyyy. Is there a setting to make this the default for dates?

Thanks

Olly :uk: (BOB member since 2008-01-24)

2

https://bobj-board.org/t/84923

Try this date check list…

Mak 1 :uk: (BOB member since 2005-01-06)

3

Try associating Object format for this date to the universe object as dd/mm/yyyy in Date/Time category. After saving and exporting the universe, you could get the desired format.

Jansi :india: (BOB member since 2008-05-12)

4

Thanks for the quick response guys - will try that and let you know how I get on.

Olly :uk: (BOB member since 2008-01-24)