Toad World® Forums

Fiscal Year Date Issue


#1

Hello,

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?

4-1-2014 11-46-29 AM.jpeg

4-1-2014 11-24-35 AM.jpeg

4-1-2014 11-24-24 AM.jpeg


#2

Hello,

I am sorry but I cannot reproduce the issue.

May I ask you to provide a little bit more information?

What version do you use?

Could you please provide step by step instructions to reproduce the error?

What database do you connect to? Is the issue database specific?

Regards

Aleksey


#3

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?

Oracle Database, tried a couple and same result.


#4

Thanks for providing additional inforamtion!

I created a task to track the issue QAT-2360

Thanks again

Aleksey