Begin and End dates

[Rick Sloan]

Hi Gang and Alpha

I had to switch to v12 to get maps problem corrected. I now have come across this.

I have a schedule report which uses the following.

Sched->date >= Var->Begin_Date .AND. Sched->date <= Var->End_date

In v11, if I wanted to print the schedule for a specific day (say March 12/14), the begin date would be March 12/14 and the end date would be March 12/14.

In v11 this works fine.

in v12 it prints a blank report.

In order to print the March 12/14 report, I have to enter March 12/14 as the first date and March 13/14 as the second date.

Rick Sloan

[Tom Cone Jr]

Re: Begin and End dates

Rick,

I'm not seeing the behavior your describe.

Consider this snippet from the interactive window:

dim begin_date as D = {02/02/2014}
dim end_date as D = {02/02/2014}

dim srch_date as D = {02/02/2014}

?srch_date >= begin_date .and. srch_date <= end_date
= .T.

I'm running build 1856_4237.

-- tom

[Rick Sloan]

Re: Begin and End dates

Hi Tom

Thanks for the response Tom.

I have a simple dialog prompting for begin date and end date.

Then run my schedule report using Sched->date >= Var->Begin_Date .AND. Sched->date <= Var->End_date as a filter.

This is a simple filter.

When I open my work v11 this filter works perfectly. When I open my work in v12 it does not. Go figure.

It has worked in all versions up to v12, and now you have to go 'one day beyond' in order for it to capture the last day you want in the report.

The problem has to be something simple if it works for you.

I just ran a hard wired date directly in the report and it still will not show a single date. I still have to go one day beyond the last day I want to show in the report.

It appears that it could be the report. I will re-design a new report from scratch and let you know.

Thanks Tom

Rick

[Tom Cone Jr]

Re: Begin and End dates

Can't help further without a copy of the database to inspect. If you are reluctant to post it here, I understand. However, if you trust me with it you can email it to me and we can talk about it offline.

-- tom
[email protected]

[Rick Sloan]

Re: Begin and End dates

Hi Tom

I am sorry, Law Society would not allow that.

I'll send you a private email if that's ok with you.

Thanks

Rick

[Tom Cone Jr]

Re: Begin and End dates

I understand. -- tom

[Bob Whitaker]

Re: Begin and End dates

We had the same issue and switched to using the between function instead and that worked fine.

[Rick Sloan]

Re: Begin and End dates

Great, I'll try that Bob.

Thanks

[Rick Sloan]

Re: Begin and End dates

I submitted an email Alpha yesterday. I have just called them as well. We should not have to change our reports and have to search for 'work-arounds' for things that should work in the first place.

At least I'm not the only one having this problem.

Hopefully they will fix this and it will reflect in the next build.

Thanks

Rick

[RCarvalho]

Re: Begin and End dates

Rick,

Has Alpha addressed this issue?

I was having the same issue with v11 release candidate 3788 4187. Looks like this bug was introduced with that release.
Works fine with v11 3381 4096 (last "official" patch). Unfortunately the release candidate addressed another bug I was experiencing. I guess I need to decide which bug I prefer to live with?

Rui

[Rick Sloan]

Re: Begin and End dates

Hi Rui

I sent customer service an email detailing the problem. I then contacted James at customer service, and we verbally went over it. James wanted me to send a copy of my DBF, which I cannot do. I was told by James he would pass it on anyway.

I have stopped using V12 until the next build or 2 comes out when I will check it again. I am sure James has passed it on and a correction was/will be made.

As a sidebar note, it appears to me that Alpha has given up on the Desktop user. I hope this is not the case. However, I see no new revolutions/additions that would warrant a costly upgrade. I reluctantly purchased v12 to correct the Google Maps issue only to find this problem.

Cheers

Rick

[RCarvalho]

Re: Begin and End dates

Rick,

From a business decision, I can understand why Alpha is focusing on web-development. I don't like it but I understand.

I guess as desktop users, the least we can ask for is that they make sure the software runs with future versions of Windows and new technologies. I would gladly pay to upgrade if it is the only way to keep my application viable.

What bothers me in this case is that something worked fine in an earlier version of 11 that is now broken in the last candidate release. (and v12). I just do not think it is appropriate to ask users to upgrade so that bugs that was introduced by Alpha be fixed.

Rui

[Tom Cone Jr]

Re: Begin and End dates

Rick, you might want to submit a formal bug report through proper channels. Use the Help menu in AA. Customer service is not the recommended avenue for submitting bug reports or getting technical assistance.

[Allen Klimeck]

Re: Begin and End dates

I think that your filter is your problem in that I don't think that it is what you think it is.

I think that you have:

Sched->date >= Var->Begin_Date .AND. Sched->date < Var->End_date

In your code! Instead of:

Sched->date >= Var->Begin_Date .AND. Sched->date <= Var->End_date

This is proofed out in that if you add an extra day it works.

[Rick Sloan]

Re: Begin and End dates

Hi Allen. The formula I use does include <= and works fine in V11 and earlier.

Tom, thanks for your help. I have sent alpha a bug report as you instructed.

I hear ya, Rui. There are some companies out there that cannot/will not use the internet regularly, for security reasons. Major companies like Target and Adobe have recently been hacked and client data stolen. I am sure these billion dollar companies spend large internet security. The internet is simply not a safe place to work on an ongoing basis. I use the internet from time to time to access my data when necessary, but I use 'Log me in' or 'Go to my PC' and the like; some of these companies have apps for cell phones. But here's the kicker. The security and the responsibility for the security is shouldered by them.

I understand the internet is Alpha's next horizon. Its business wise. However, there are many desktop users out there still willing to pay for usable upgrades.

Cheers to all