When you said you saw no change, does it show the datetime stamp? Tom Hart
________________________________ From: Dennis McGrath <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wednesday, February 26, 2014 12:33 PM Subject: [RBASE-L] - RE: date time Bummer. Normally, this is sufficient for a timestamp, but your requirements are stricter than that. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, February 26, 2014 12:08 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: date time With or without the dot it puts the time when the row first comes on the screen not when the information is entered. The time on the form changes when I enter the row. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, February 26, 2014 12:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: date time That should not be. Did you put the string .#NOW in the default value definition of the control? Notice the dot in front of #NOW Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, February 26, 2014 11:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: date time Dennis, I did as you suggested but the time entered is not the actual time of entry but of the time the form started. I tried staying on the form and doing multiple entries but the times in the table were as much as one minute off. James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Wednesday, February 26, 2014 10:30 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: date time I'm assuming you are using a form based on the table, not a variable form. Make the default value of the TimeComp dbedit control = .#NOW you will find this setting under the effects tab of the control. The only time this setting has any effect is when you are inserting a new row, which is what I believe you want. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, February 26, 2014 9:41 AM To: RBASE-L Mailing List Subject: [RBASE-L] - date time I have never used the DATETIME data type before. I set up a table with the field Timecomp having a DATETIME datatype On a form I want the DATETIME to show (constantly refreshing). This will be attached to a field above. When they hit a button The row will be saved (along with other info) with this timestamp in the field. So each row will have a different time attached to the row. I tried making a variable on the form equal to the field. Then I added the system variable (date and time) to the form related to the above variable. I put into the FORM timer to REFRESH this variable using the comp ID. I did not see any change. Any suggestions? James Belisle Making Information Systems People Friendly Since 1990
