I’ve been made aware of an issue within LO whereby date prompts don’t seem to function properly.
If the date filter is set to 24/03/2016 the query returns data if the date filter is set to 31/03/2016 no data is returned.
However, checking the query in the old version of LO returns data.
The query also works fine when built within Webi.
The Oracle database would be working with dd/MM/YYYY formatted dates.
The user tried recreating the query from scratch and the issue still exists. He also noted the query, which is a very simple one, works intermittently for previous dates.
Live Office 4.1 SP5 Patch 4 (14.1.5.1634)
Excel 2010
Any ideas?
kbannon (BOB member since 2015-06-26)