filter on time of appt

[DLDavis]

I use a p9 database to track client services. I can filter the database by any field...exept the one I have where I record the time a client is to be seen. For instance, if I want to list all appointments that are at 4:30, I get an error message...something about an invalid operator. The field is a DATE field. I even went back and changed it to alphanumeric...same result. How can I filter records by time field?

 

[Langley]

You have to put the value in "quotes". Mac

"Do not delve too deeply in the arts of your enemy and so become ensnared by them"

langley_mckelvy@cd4.co.harris.tx.us

 

[Guest_imported]

Tried that too (putting it in quotes)..got same message. Will try it again...while holding my lower jaw to the right and turning my head to the left...while humming Dixie...and and and and bumping my knee against the table.

Tanx.

Dan

 

[Langley]

Paradox and time calcutations, filters, etc... are a pain. Remember that paradox stores times as long integers and displays them according to Windows display settings (in control panel). If you don't match the display, the filter won't work. For example: > 6:19:00 PM works on my PC because that matches my time settings (seconds have to be included).

I just tested this and the quotes are not necessary when you do it manually, but might be required if you do it in OPAL.

Mac

"Do not delve too deeply in the arts of your enemy and so become ensnared by them"

langley_mckelvy@cd4.co.harris.tx.us

 

[Guest_imported]

My friend..you did it again! Was able to get p9 to print all 4:30 appts...when I put them in quotes...and typed it thusly:

"4:30 PM".

I'm trying to figure out how to fix another problem (surprised?). I have a guy who helps me with some cases...
so...I tried to add a field to the database. I added a field called "Gordon", and made it a logical field. It was added, but it won't show up when I use a filter to show me only records where the value in the Gordon field is "y". I also cannot get it to see the new field when I add it to a FORM I'm using for data input. When I try to "DEFINE FIELD", the new field is not in the drop box. Any ideas?

 

[Langley]

A couple of things about logical fields. I don't use them because I typically run calculations on the fields I would consider calculation field candidates. Instead, I make them Short Integer fields, assigning a default value of 0 and a picture value of 0,1 for a checkbox. A 1 is true and a 0 is false. That way I can do a simple calc sum on that field to see how many times the value was true. Anyway, back to your problem. Filters are case sensitive, so check your table and make sure that the data matches the filter you are trying to set. Your table might have "Y" (or even "True&quot, and not "y".

As for it not showing up in the table field list, that almost has to be some kind of human error. If you can't discover what it is, try adding a second copy of the table to the data model and look at that drop down list. If the field is there, delete the original copy in the data model, leaving only the copy.


Mac

"Do not delve too deeply in the arts of your enemy and so become ensnared by them"

langley_mckelvy@cd4.co.harris.tx.us