Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining a birthday
Message
 
To
22/01/2002 15:29:41
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00608612
Message ID:
00608622
Views:
17
could you use:
Select Contact.*
where between(contact.dob, date(), date())
>Hi Folks -
>
>If I have a table which contains a contact name and date field, dob. What command would I use to filter the data down only to show the contacts with a birthday (based upon the dos clock date) of today ?
>
>Would I need to convert the month and day to character? If so is that the only way?
>
>Thanks,
>
>Larry
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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform