Date function help

[jbphoenix]

I have a form with a Date field. That date field is defaulted to = Date(). That works fine. Also there are a series of User Initial and dates boxes next to several question. So basically after a step has been completed the user enter's their Initials and the date is automatically filled in for them. The problem occurs when the user closes the form and comes back tomorrow to complete it. So the date in previous step is 8/14/08. If i were to go back to that form today and complete a step by entering my initials the date would say I did it on the 14th instead of today. Why is this happening?

 

[rainman89]

because you are writing the record with that date setting it as default only works when its blank

you would need to have a save button where the yourdatefield=date() for it to write over everytime.

 

[jbphoenix]

Ok I understand that. I don't think explained my problem very well. I've attached a picture of which date field I meant.

I need the date next to RD Eng. Or Mfg. Eng. to change to today's date after the user enter's their initials. I already have the code setup in after update.

 

[rainman89]

if you already have it set up, then this should work. put me.yourdatefield=date() in the afterupdate of your initials textbox you can remove the default
all together

 

[jbphoenix]

Here is the code I have in the afterupdate Me.txt_Date_4_ME_RD = Date. There is nothing in the default and still after the update I'm getting 8/12/2008. That's the date at the top of the form.

 

[rainman89]

what if you use today instead of date?

and if that doesnt work, post up a sample id like to take a look

 

[jbphoenix]

Here is a scaled down version of the DB. If you look up ECO id 837-08 838-08 or 839-08 and put in your initials in the RD ENG.or Mfg Eng. box the date will be updated but not to today's date.

Thanks for taking a look.

 

[rainman89]

ok before you go anyfurther you do not want to use DATE for the fieldname in the table changeit to mydate or ECODate

also is the top date supposed to be today or the date the file was entered??

 

[jbphoenix]

The top date is the date the file was entered. Thanks for pointing out DATE as a fieldname. I usually don't do that.

 

[rainman89]

The top date is the date the file was entered. Thanks for pointing out DATE as a fieldname. I usually don't do that.

Here ya go. Take a look and see what i did. I created an unbound field called today and set the value to that textbox. It doesnt like

me.txt_1=date in VB

hope this helps

 

[jbphoenix]

Thanks for all your help Ray!

 

[rainman89]

Not a problem. Glad too. I always understand better when i can see whats going on!