We have a bizarre Fiscal Year date issue that popped up all of a sudden this morning. Our fiscal year date range values give the following 2 errors below. However, when setting the Fiscal Calendar Type to 5/4/4 or anything besides 'Normal' it will run just fine. Any ideas?
Well, we just found out an additional detail to make things more bizarre. If we change our system date to 3/31/2014 everything works fine and likewise changing it forward to 4/02/2014 everything works just fine.
EDIT: It seems like our workaround will do for now
What version do you use? We are using Toad Data Point Professional 3.4
Could you please provide step by step instructions to reproduce the error?
1. Where clause on any query
**2. Fiscal Year Date Range Value Selection **
3. Execute SQL - ERROR
What database do you connect to? Is the issue database specific?