Sql to dbase

[tekmakesmetwitch]

apparently i am doing something wrong...what i want to do it create a automated process to take a particular date field in my Goldmine and create the following condition...if the date in the named field is older than the current date...then i want to have that date forward 30 days from current date...in dbase. Forgive me as I am a "draw me a picture" type of being!!

 

[PHV]

Provided your Goldmine table is linked in your access DB, here a simple update query:
UPDATE yourLinkedTable
SET yourDateField = 30 + Date()
WHERE yourDateField < Date()

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Hi,

"...if the date in the named field is older than the current date...then i want to have that date forward 30 days from current date..."

Please explain what you mean?

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]