Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

dBase trigger on "todays"date.

1 view
Skip to first unread message

Bruce Heller

unread,
Jan 11, 2000, 3:00:00 AM1/11/00
to
In a trigger field, of an automated process, can we compare a date field
with today's date? Any clues what that expression would look like?
Rob Harrison

Greg Gilman/GM

unread,
Jan 12, 2000, 3:00:00 AM1/12/00
to
Bruce,

An expression to compare today's date with a date field would look like
this.

date()=contact2->lastconton

date() returns the current system date as a date value

You can also compare the date to a string value

dtoc(date()) returns the date as a string in the format 01/12/00

dtos(date()) returns the date as a string in the format 20000112


- Greg,

GoldMine Support
Visit our online KnowledgeBase at
http://kbase.goldminesw.com

Bruce Heller <Br...@xenex.com> wrote in message
news:lFQ1slJX$GA.230@gmnews2...

0 new messages