Select data does not work


#1

Hello Friends,
I have a database with a field named “WedAnniversary”.
Several of the entries would have the word “October” in it.
I have created a procedure that simply selects records with “October” in it.
Below is the procedure:
Select «WedAnniversary» Contains "October"
It does not select anything.

What am I doing wrong?


#2

Is WedAnniversary a text field, or a date field?


#3

I have never tried this before attached a screenshot. I hope it works. I am pretty sure it is a text field.


#4

A date is a number. It doesn’t contain the name of any month. Try

Select datepattern(WedAniversary,"Month") contains "October"


#5

Thanks Dave,
I cut and pasted the line into the procedure and it did not work. Then I realized that your “Anniversary” only had one “n” in it. As soon as I made it “Anniversary” it worked great.
This forum is great. Thanks for the help Dave.