getting dates without years

Thread View: borland.public.vdbase.data.sql

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Martin Holmes Tue, 13 Apr 1999 00:00

#73

Author: Martin Holmes
Date: Tue, 13 Apr 1999 00:00

16 lines
1017 bytes

I have had trouble with the following code.  I can't seem to pass a
variable into an Extract statement.  Any help in getting dates out of
the table would be appreciated.  Things like birthdays which you only
want to enter once but come around every year..

select  name, reminder, event, eventdate, comment
from Grandma
where reminder<=:Reminder
and eventdate>=:Eventdate
or
event="Birthday"
and
(EXTRACT(Month from reminder) <=Extract(Month from :Reminder))
and
(EXTRACT(Month from eventdate) >= Extract(Month from :Eventday))
and...

Re: getting dates without years

#74

Author: Geoff S. Wass ( dBVIPS )
Date: Fri, 16 Apr 1999 00:00

18 lines
1051 bytes

Martin,

To start with, your variable names should be different from the field
names of the table you are working with.

As well, these news groups are dead. Post your question again in the NEW
news groups. You can access them through the link given below my
signature.


--
Geoff Wass ( dBVIPS )
Kuala Lumpur, Malaysia

=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=

*>*> Visit the NEW! dBASE Inc. news groups on the news server
news://news.dbase2000.com <*<*

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads