Can't get a Date to work correctly

[Wingwalker]

I have a [Customer] file that contains all basic customer information including the customers eMail address. My problem is i’m unable to get my RecordDate field to populate with the right Date. It's set up as a Date field: Creation Date. When I send an email (I use SMTPit) I never get the date I’ve actually sent the email.

 

I think I know the problem. I’m just performing a find on those I want to email and mailing. I’m not creating a new record which would trigger the Creation Date. So how do I get the date I actually mailed something, into the RecordDate so I can keep track of what was sent on any given day, if i'm not actually creating a new record. I keep track of this in a separate file (a data file) called [sent Emails].

 

Thanks for your help.

[Henk B]

In your script that sends the mail add the following script step:

Set Field [DBname::DateField; Get ( CurrentDate )]

[Wingwalker]

Hi Henk,

 

I added the Get statement to the script that sends the email, but it changes the date for more than just the emails I'm sending. I sent quite a few emails yesterday, and when I sent a couple emails this morning just to check it out. It changed the dates on yesterdays emails to todays date!

 

Is there anything else I can do?

[Vaughan]

Make a separate field for the date the email was sent... EmailDate. Update it each time the email was sent.

 

A better but more complex method would be to make a related table/file to hold the dates the email was sent, that way you could track not just the last time email was sent. It'd also solve record locking problems in multi-user too.