Hi All
I have written a report with data prompts dd/MM/yyyy . When users run the reports from India , their prompt comes up as m/d/yyyy.
When the report is run it simply display #ERROR in all the cells where the date is being referenced, Runnning it in the UK, there are no issues
Any help would be appreciated
regards
Sims
BI Launchpad Preferences - Locales and Timezones - change for Indian users…
imho it depends how do you write the prompts…
if you write it with A parameter as a text and then manually format it using some db date function then you have an issue if another regional settings is used.
if you write it with D parameter then the date syntaxe would reflect their regional settnigs and you should get a propper/some result.
cheers Tomas