Quattro Pro Criteria

[AJ]

I'm trying to extract data from a Quattro Pro 5.0 spreadsheet using
a criteria formula that looks like this:

OrderDate
+OrderDate > @DATE('07,6,04') #AND# +OrderDate < @DATE('07,6,31')

Syntactically I see no reason why this shouldn't work. I have also
tried

OrderDate > @today-31 #AND# +OrderDate < @today-1, and innumerable
other variations and I just can't seem to get it to work the way I need it.

It would appear that everything is setup properly. If I type in a
single date number it will locate the matching records. I also created
field names from the headings though I am not 100% certain this
was done properly as it references only the heading row and nothing
below it - Borland didn't put a lot of effort into explaining this in
any detail.

I'd like to ultimately be able to have these criteria fields reference
a start date cell and an end date cell for lookups so I don't have to
muck around in the formula to change anything.

Anyone know what I am doing wrong here?

I can provide more clarification if need be but I think this pretty
well describes it.

Any help will be greatly appreciated.

Thanks

AJ

[Michael J Davis]

Post by AJ
I'm trying to extract data from a Quattro Pro 5.0 spreadsheet using
OrderDate
Syntactically I see no reason why this shouldn't work. I have also
tried
other variations and I just can't seem to get it to work the way I need it.

I thought I could quickly solve this (QPW 6.03) but have failed
completely.

Well almost.

I looked at @datevalue()
and found that the help showed single quotes, but it worked only with
double quotes!

@DATEVALUE("04/13/04")

But the @DATE function doesn't require quotes at all.

@DATE(93,11,18) = 34291
Is that it?

BUT it doesn't work for Y2K because it only works for 2 digit years YY.

Hope it helps

Mike

[The reply-to address is valid for 30 days from this posting]

[AJ]

Hi Mike.

Thanks for giving it a try!

Tried that as well, no go.

I think Y2k may be an issue but
I have also tried it with a serial
date function (@today) but as that
doesn't work either there is something
else going on here.

As I mentioned, when I put in a single
number all by itself, that seems to work
fine. But I cannot get ANY formulas to work.

This is very depressing!!

Anyhow, if you think of something else please
let me know.

Thanks again.

AJ

Post by AJ
I'm trying to extract data from a Quattro Pro 5.0 spreadsheet using
OrderDate
Syntactically I see no reason why this shouldn't work. I have also
tried
other variations and I just can't seem to get it to work the way I need it.

I thought I could quickly solve this (QPW 6.03) but have failed completely.
Well almost.
and found that the help showed single quotes, but it worked only with
double quotes!
@DATEVALUE("04/13/04")
@DATE(93,11,18) = 34291
Is that it?
BUT it doesn't work for Y2K because it only works for 2 digit years YY.
Hope it helps
Mike
[The reply-to address is valid for 30 days from this posting]

[AJ]

Still have not solved this issue. If there is anyone who can help
I'd be much obliged.

Thanks

Post by AJ
Hi Mike.
Thanks for giving it a try!
Tried that as well, no go.
I think Y2k may be an issue but
I have also tried it with a serial
doesn't work either there is something
else going on here.
As I mentioned, when I put in a single
number all by itself, that seems to work
fine. But I cannot get ANY formulas to work.
This is very depressing!!
Anyhow, if you think of something else please
let me know.
Thanks again.
AJ

Post by AJ
I'm trying to extract data from a Quattro Pro 5.0 spreadsheet using
OrderDate
Syntactically I see no reason why this shouldn't work. I have also
tried
other variations and I just can't seem to get it to work the way I need it.

I thought I could quickly solve this (QPW 6.03) but have failed completely.
Well almost.
and found that the help showed single quotes, but it worked only with
double quotes!
@DATEVALUE("04/13/04")
@DATE(93,11,18) = 34291
Is that it?
BUT it doesn't work for Y2K because it only works for 2 digit years YY.
Hope it helps
Mike
[The reply-to address is valid for 30 days from this posting]

[RUSS BARTOLI]

I use Lotus 1-2-3 but have some ideas to try...
Have you tried using @date(107,7,24) for 7/24/2004?
Or filtering for dates in your database which are not exact integers via
something like: @round(date,0)<=@date(107,2,24)?

Just some ideas to try...

Post by AJ
Still have not solved this issue. If there is anyone who can help
I'd be much obliged.
Thanks

Post by AJ
Hi Mike.
Thanks for giving it a try!
Tried that as well, no go.
I think Y2k may be an issue but
I have also tried it with a serial
doesn't work either there is something
else going on here.
As I mentioned, when I put in a single
number all by itself, that seems to work
fine. But I cannot get ANY formulas to work.
This is very depressing!!
Anyhow, if you think of something else please
let me know.
Thanks again.
AJ

Post by AJ
I'm trying to extract data from a Quattro Pro 5.0 spreadsheet using
OrderDate
Syntactically I see no reason why this shouldn't work. I have also
tried
other variations and I just can't seem to get it to work the way I need it.

I thought I could quickly solve this (QPW 6.03) but have failed completely.
Well almost.
and found that the help showed single quotes, but it worked only with
double quotes!
@DATEVALUE("04/13/04")
@DATE(93,11,18) = 34291
Is that it?
BUT it doesn't work for Y2K because it only works for 2 digit years YY.
Hope it helps
Mike
[The reply-to address is valid for 30 days from this posting]

--
When asked what he thought about
Western Civilization, Ghandi quipped,
"I think it would be a good idea".