Convert Access Sql statement to Goldmine Dbase 1

[tekmakesmetwitch]

Can anyone tell me how to convert the following sql string
Format(Now()+30,"mm/dd/yyyy")
into a dbase expression?

 

[SkipVought]

Hi,

A Google got me

http://support.frontrange.com/support/goldmine/pdf/6.5/usingdbaseexpressions.pdf

How about this...

DTOS(Date())

then use SUBSTR to create the mm dd yyyy order that you need.


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]

 

[tekmakesmetwitch]

apparently i am doint 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!!

 

[SkipVought]

Then why change the date to text? That destroys the value!

"...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..."

Could you 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]

 

[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

 

[tekmakesmetwitch]

ok..i don't want to change it to text. I will try to explain the best I can...I have a particular field in GoldMine..it is called a follow up date. It tells our sales force when to call this customer. If they do ot get to this customer in time it will just lay dormant until they remember to call...instead of laying dormant, i want the date to autoforward 30 days from the current date that i run the process...i do not want the process to run unless i tell it to though....does this help you understand? Sorry to be so confusing.

 

[SkipVought]

Look at PHV's solution.

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]

 

[tekmakesmetwitch]

i am not linked to my access

 

[SkipVought]

Haw about Forum290?

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]

 

[tekmakesmetwitch]

THX U very much. You have been great help. That is exaclty where i need to be.