>>could you use:
>>
Select Contact.*
>>where between(contact.dob, date(), date())
>
>Roi,
>
>That won't work. If dob is 1/22/60, it won't be between date() & date(). Pretty clever try tho :-)
>
>Rob
Doh! You're right. Just checked the FAQ and found something similar, I should have looked there first.
Larry, see FAQ#7922 - How to find if the client's birthday is between the given dates. You should be able to use something similar.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!